Full Accumulative Issue

[#1]

Hi,

I have more than one dimension, when I select full accumulation it is not working as expected and I read few post that need to use range sum function, but I have difficult formula not sure how to use rangesum, pls guide me below is the formula.

=if([Cost]<=0,0,sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}Sales)

/

sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}TOTAL Sales))

Thanks,

[MK_QSL]

Difficult to fully understand your formula without knowing your application but you can try below

=if([Cost]<=0,0,

RangeSum(Above(sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}Sales),0,Rowno()))

/

sum({$<Nm_D_Dt = {">=$(vStartDate)<=$(vEndDate)"},M_Com=>}TOTAL Sales))

[#3]

Thanks for the response, but didn't worked the formula.

Thanks,

[MK_QSL]

Can you please provide sample apps or sample data to work similar to your apps.

[#5]

It is one of my project formula, what I am trying to do is that I need full accumulative and I have more than one dimension, so my above formula is not showing full accumulative values. when I do some sample data I get perfect but this formula not sure how to use range function.

Thanks,