Skip to Content
0
Feb 17, 2015 at 03:05 PM

Running total with exclusion criteria

14 Views

ID COUNT FLAG

21 2 Y

45 3 NULL

16 4 N

14 11 N

13 9 Y

19 0 NULL

I am trying to create a running total calculation as SUM for the count field, but i only need to consider records with FLAG as NULL or N. Where can i define that exclusion of records with FLAG as Y in Running total calculation? I really appreciate your help! Thanks!