Rangesum issue

[subathra]

Hi,

Is there anyway to do this calculation without using aggr function

Sum({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}

Aggr(RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())),Date))

[prat1507]

Hi

Can u plz share a sample app with scrambled data?

Regards

Pratyush

[subathra]

Hi

i cant share the app..the app size is little bit large

[sunny_talwar]

May be this

RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())) * Avg({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}1)

[subathra]

Hi sunny,

It is working ...but i am not getting the exact value

[sunny_talwar]

Do you have Date as your dimension? Also, do you have the same sort order in your chart as in your script?

[subathra]

Thanks sunny..Its working...but how can i display the total value

[sunny_talwar]

What is total when you are accumulating? Sum of rows or the last accumulated value?

[subathra]

i am displaying this measure in a table...so here i need to show the total value as label

[subathra]

sum of the accumulated values is my total