topic YTD Calculation in Table in App Development

YTD Calculation in Table

ramkrishna86 — Thu, 25 Jan 2018 10:20:21 GMT

Hi,

Can anybody please suggest about YTD calculation in table with filter selection on dimension. I am able to write below code which works fine if value are selected in filter but doesn't work if no value are selected.

If(GetSelectedCount(Period)=1,

aggr(rangesum(Below(total sum({<Period=>}Value),0,$(vMonthDiff))),Period),

aggr(rangesum(Below(total sum({<Period=>}Value),0,Right(Period,2))),Period))

Also, Please find attached QVF.

Thanks in Advance!

Re: YTD Calculation in Table

sunny_talwar — Thu, 25 Jan 2018 12:50:38 GMT

After what selection does this work? I tried selecting Period and it doesn't seem to be working... am I missing something here?

Re: YTD Calculation in Table

ramkrishna86 — Thu, 25 Jan 2018 13:31:58 GMT

Hi Sunny,

When you also select vaue from AccCls and AccN then it is working.

Please suggest other approach to calculate YTD.

Thanks,

Re: YTD Calculation in Table

sunny_talwar — Thu, 25 Jan 2018 13:36:45 GMT

Check this

If(GetSelectedCount(Period)=1,

aggr(rangesum(Below(Sum({<Period=>}Value),0,$(vMonthDiff))), AccCls, AccNm, Period),

aggr(rangesum(Below(Sum({<Period=>}Value),0,Right(Period,2))),AccCls, AccNm, Period))