Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
please help to explain the case below. Thanks in advance.
For variable V_MAXMONTH, We define Let V_MAXMONTH=Month(TODAY()) in data load, my confuse was that we cant calculte $(V_MAXMONTH) in TEXT box, and also how to use the month variable in set analysis. Thanks in advance.
Best Regards,
Haifeng
try as below:
Let V_MAXMONTH = Month(TODAY());
in your textbox use only the variable name without $ expansion.
set analysis example:
sum( {< your_month_field = {"$(V_MAXMONTH)"} >} your_measure )
I hope this helps.
One workaround is to create the variable in the Variables section in the Edit Sheet.
Try like below.
in script
Let vMaxMonth = Month(Today());
Expresion
=vMaxMonth
try as below:
Let V_MAXMONTH = Month(TODAY());
in your textbox use only the variable name without $ expansion.
set analysis example:
sum( {< your_month_field = {"$(V_MAXMONTH)"} >} your_measure )
I hope this helps.