topic Re: Can Sunny SET expression be modify to make it more dynamic ? in App Development

Can Sunny SET expression be modify to make it more dynamic ?

paulyeo11 — Thu, 28 Apr 2016 01:24:07 GMT

Hi All

I have got this SET expression from Mr sunny :-

Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))

My question is , it is possible to modify to change the above expression to make it more dynamic. So when user not select any date it will display current month and year amount.

If user click on year=2015 , month = march. The above above amount will change to Last year same period amount.

Paul

Re: Can Sunny SET expression be modify to make it more dynamic ?

paulyeo11 — Thu, 28 Apr 2016 01:24:54 GMT

my QVF

Re: Can Sunny SET expression be modify to make it more dynamic ?

sunny_talwar — Thu, 28 Apr 2016 01:29:51 GMT

What would be a expected value when you select 2015 and March?

Re: Can Sunny SET expression be modify to make it more dynamic ?

paulyeo11 — Thu, 28 Apr 2016 01:34:55 GMT

Hi Sunny