Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
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)