How to running sum based on certain conditions

[Former Member]

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.

[amitrathi239]

try this.

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