How to dynamically change the field in set analysis

[ronaldwang]

If I want to give user selection on what field to have condition on, say accounting date or payment date, apart from using if statement, is there a way I can may [Accounting Date] as in below statement dynamic so that it can be changed to [Payment date] based on user selection (list box etc)

sum({$<[Accounting Date]={">=$(=vStartDate+0) <=$(=vEndDate+0) "}>}Amount)

[sunny_talwar · Accepted solution]

Create an variable and give user the option to select between Accounting Date and Payment Date and then use that variable within dollar sign expansion

Sum({$<$(vDateType) = {">=$(=vStartDate+0)<=$(=vEndDate+0) "}>}Amount)