Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm looking to see if anyone could fix my problem.
I can create a variable on the front end of my app, I call it ThreeYears and in the expression editor it is defined as so:
You need to prevent the $ expansion from occuring in the script for your variable definition. Try defining the Let statement in the script like this:
Let ThreeYears = '>=$'&'(=monthstart(addmonths(max(MonthYearComplete),-35)))<=$'&'(=addmonths(monthend(max(MonthYearComplete)),0))';