Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
I have created a variable with the following syntax
vPeriod ={"<=$(=MAX(MONTH))"}
But when I use this variable in below set expression It does not work.
sum({<MONTH={$(vPeriod)>}ACTUAL)
Could you please let me know where I have made the error and let me know how to correct it please.
try this
vPeriod =MAX( TOTAL MONTH)
sum({<MONTH={"<=$(vPeriod )"}>}ACTUAL)
Thanks for your reply. Here Total month can not be applied since month will be selected depending on the selection in list box
Try this
You may need to use GetFieldSelections
LET vMaxMonth = '=if(GetFieldSelections(MONTH_FIELD)>0,max(MONTH_FIELD),max(month(today()))-1)';
Thanks
It does not give desired output