Error in set modifier ad hoc element list: ',' or ')' expected in formula

[100Glizzy]

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!

[Anil_Babu_Samineni · Accepted solution]

@100Glizzy This maybe?

sum({<Rep_Year_Month = {"=$(Max(Rep_Year_Month))"}>} [Sales Net])

[100Glizzy]

Almost, this fixed it! Thank you!!

sum({<Rep_Year_Month = {'$(Max(Rep_Year_Month))'}>} [Sales Net])