Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hi
Can u plz share a sample app with scrambled data?
Regards
Pratyush
Hi
i cant share the app..the app size is little bit large
May be this
RangeSum(Above(Sum({$<EntryDate={"<=$(=max(EntryDate))"}>}ClosingBalanceAmount),0,RowNo())) * Avg({$<FiscalYear={"$(=Year(Max(FiscalYear)))"}>}1)
Hi sunny,
It is working ...but i am not getting the exact value
Do you have Date as your dimension? Also, do you have the same sort order in your chart as in your script?
Thanks sunny..Its working...but how can i display the total value
What is total when you are accumulating? Sum of rows or the last accumulated value?
i am displaying this measure in a table...so here i need to show the total value as label
sum of the accumulated values is my total