Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, experts!
I have the following inconvenience, I need the last year before the selected one and then use it in the set analysis of another variable, all this inside the load script.
I tried this but only work if I use the content of variable directly on text object but not work if I use "Cant" in other formula in load script:
([Year] is a Field).
SET Cant= COUNT({<MonthYear,Year={$(=MAX([Year])-1)}>} DISTINCT IF(Date_Holiday >= ($(vInv_Date)) ) ); (Work on Text Object)
SET OtherFormula = SUM ( $(A) + $(Cant) ) ; (Not Work in Load Script)
Thanks in advance!
But that is precisely the problem, in order to be maintainable and not indecipherable code, I need to solve it in the load script, and NOT in the text object, that is to say, I need to use the variable created in the script in the text object because the code in the text object itself is already complex.
I think you can use this formula to pass it to Variable. Do fix the Data in Table so that it has associations and try.
I think you would have to have a variable after a load of the table. let me check
I think you will need LET instead of SET