Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Having an issue get it to work, I think its probably simple fix. It is just to get the sum of LAST_UNIQUE for the latest record of the variable Brand_Weeks=.
This set analysis work ----> =sum({$<Brand_Weeks={47}>}LAST_UNIQUE)
But if I remove the number 47 and replace with a variable, Max(Brand_Weeks), that is numeric it doesn't work
=sum({$<Brand_Weeks={Max(Brand_Weeks)}>}LAST_UNIQUE)
I set the variable Brand_Weeks to be a numeric in the load script using this Num#(Brand_Weeks) as Brand_Weeks, I also tried Num(Brand_Weeks) as Brand_Weeks in the load script
SUM({$<Brand_Weeks={$(=Max(Brand_Weeks))}>} LAST_UNIQUE) should do it.
SUM({$<Brand_Weeks={$(=Max(Brand_Weeks))}>} LAST_UNIQUE) should do it.
perfect thank you