topic Re: Dynamic selection in App Development

Dynamic selection

Karahs — Thu, 21 Dec 2017 10:32:02 GMT

Hello Community,

I want to get sum of amount for current selection of year and then subtract value of its previous year from that.

Below expression works in static manner, i want it to work dynamically based on selection of years.

((((sum({<Reference={'1','2','3'},[FY Year Name]={'2017-18'} >}Amount))-

(sum({<Reference={'1','2','3'} ,[FY Year Name]={'2016-17'}>}Amount)))/(sum({<Reference={'1','2','3'} ,

[FY Year Name]={'2016-17'}>}Amount))))

This is the result of the above expression, but i want it to change based on selection in year filter.

Thanks in advance!

Re: Dynamic selection

felipedl — Thu, 21 Dec 2017 12:01:40 GMT

Your year field is a text one, so it would be better if you transform it into a number format for better handling.

Instead of putting a year comparison in the year field (2017-18) just do a normal number, like 2017 and 2018 as separate rows in the field and the set expression would be like:

((((sum({<Reference={'1','2','3'},[FY Year Name]={'$(=Max(Year))'} >}Amount))-

(sum({<Reference={'1','2','3'} ,[FY Year Name]={'$(=Max(Year)-1)'}>}Amount)))/(sum({<Reference={'1','2','3'} ,

[FY Year Name]={'$(=Max(Year)-1)'}>}Amount))))

Re: Dynamic selection

Karahs — Thu, 21 Dec 2017 12:39:15 GMT

Thank You Felip , it works perfectly

Re: Dynamic selection

felipedl — Thu, 21 Dec 2017 12:40:13 GMT

Glad it helped .