Skip to Content
0

How to running sum based on certain conditions

Apr 11 at 02:23 PM

18

avatar image

Hello BO Masters,

I have a question related how to get running sum in BO based on certain conditions.

As you can see the attached table.I only want to get running total when the area code equal to 200 or 203. I tried different formula, but none of them are successful.

Anyone can give me a suggestion? thanks so much.

image-18.png (18.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Apr 11 at 03:50 PM
1

try this.

=RunningSum(If([Area Code]InList (200;203)) Then ([Order]) Else 0) Where (([Area Code]InList (200;203)))

Share
10 |10000 characters needed characters left characters exceeded