topic Re: Rangesum issue in App Development

Rangesum issue

subathra — Wed, 27 Sep 2017 09:41:26 GMT

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 — Wed, 27 Sep 2017 10:23:57 GMT

Can u plz share a sample app with scrambled data?

Regards

Pratyush

subathra — Wed, 27 Sep 2017 10:26:29 GMT

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

sunny_talwar — Wed, 27 Sep 2017 11:33:57 GMT

May be this

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

subathra — Wed, 27 Sep 2017 11:43:14 GMT

Hi sunny,

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

sunny_talwar — Wed, 27 Sep 2017 11:53:24 GMT

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

subathra — Wed, 27 Sep 2017 11:58:23 GMT

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

sunny_talwar — Wed, 27 Sep 2017 12:02:37 GMT

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

subathra — Wed, 27 Sep 2017 12:07:37 GMT

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

subathra — Wed, 27 Sep 2017 12:08:59 GMT

sum of the accumulated values is my total

sunny_talwar — Wed, 27 Sep 2017 12:14:13 GMT

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

subathra — Wed, 27 Sep 2017 12:17:21 GMT

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

sunny_talwar — Wed, 27 Sep 2017 12:19:00 GMT

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

Best,

Sunny