Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've been trying to do something relatively simple but I just don't see where I'm going wrong. I'm still figuring out the $ application within QS scripting. I feel like the fix is relatively simple but this isn't something I've been able to find myself..
On the front end (chart view), I want to select the latest date (Rep_Year_Month) from a range of dates selected in the filter pane. However I am getting the issues mentioned in the title. Looking up various solutions removes the variable I'm trying to isolate.
sum({<Rep_Year_Month = {$(=Max(Rep_Year_Month))}>} [Sales Net])
Thank you!
@100Glizzy This maybe?
sum({<Rep_Year_Month = {"=$(Max(Rep_Year_Month))"}>} [Sales Net])
@100Glizzy This maybe?
sum({<Rep_Year_Month = {"=$(Max(Rep_Year_Month))"}>} [Sales Net])
Almost, this fixed it! Thank you!!
sum({<Rep_Year_Month = {'$(Max(Rep_Year_Month))'}>} [Sales Net])