Skip to Content
avatar image
Former Member

How to running sum based on certain conditions

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 11 at 03:50 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded