Running Totals

[tmumaw]

I have a chart that I am trying to create a running total on.  I am using this as the formula, but Jan always comes out to be 1.00 any ideas what I am doing wrong?  I have for example Jan: 250, Feb: 300, Mar: 300.  I am looking for Jan 250, Feb 550, Mar 850, etc.

Thanks

RangeSum(above(Sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1},[Plan Description] ={'Sales Plan'}>} [Plan_Dollars])),0,RowNo())

[tmumaw]

Sorry had a meeting the rest of the day.  I got the same thing 1.00 in January and the values in Feb - July

[sunny_talwar · Accepted solution]

How about you use this expression:

Sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}, [Plan Description] ={'Sales Plan'}>}[Plan_Dollars])

and select full accumulation from the expression tab?

[tmumaw]

You are the man.  It works.

[tmumaw]

That was a tricky one.

[sunny_talwar]

I am still not sure why RangeSum(Above()) did not work. I would have expected it to work.

[tmumaw]

Me too.  I have a lot of other apps that use it.  Might have to do some more digging and question asking to find out why.  Thanks a lot for your help.  I see you are a early bird too.