12 Replies Latest reply: Sep 27, 2017 8:19 AM by Sunny Talwar

# Rangesum issue

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))

• ###### Re: Rangesum issue

Hi

Can u plz share a sample app with scrambled data?

Regards

Pratyush

• ###### Re: Rangesum issue

Hi

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

• ###### Re: Rangesum issue

May be this

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

• ###### Re: Rangesum issue

Hi sunny,

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

• ###### Re: Rangesum issue

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

• ###### Re: Rangesum issue

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

• ###### Re: Rangesum issue

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

• ###### Re: Rangesum issue

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

• ###### Re: Rangesum issue

sum of the accumulated values is my total

• ###### Re: Rangesum issue

If this is in a table, you might be able to use total function = 'Sum'

• ###### Re: Rangesum issue

k sunny...i will look into that...thanku so much

• ###### Re: Rangesum issue

Sounds good... please close this thread by marking correct and helpful responses if and when you get what you were looking for.

Best,

Sunny