problem with chart inter record function

[#1]

I have a strange problem.I need to calculate running total for a chart, I was able to do it by below() and noofrows() function.the dimensions are customer and monthyear,but extra rows with zero values are added for every monthyear.Suppresing zero values and null values was not useful.Any ideas please how to get rid of the zero values?

[#2]

hi kevincool,

Try to solve it on script level and stop loading of extra rows with zero value.

Regards

-Anil

[CELAMBARASAN]

Is it possible for you to post your expression?

May be use of Aggr function you can solve this..

[#4 · Accepted solution]

Thanks all, I sorted it out now.The working expression is:

NUM(RANGESUM(RANGESUM(Debit, Credit), Below(TOTAL RANGESUM(Debit, Credit), 1, NoOfRows()-1)), e_currency_format_decimal)

where debit and credit are two different expressions and I have to show a running total of the both in descending order of monthyear.