Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I have an issue with set analysis syntax. I wat to take UID from period between max and min dates and count distinct UID values. And receive message that "error in set modifier ad hoch element list: ',' or ')' expected"
And I can't get where these symbols are expected.
Could you please help to understand what wrong with formula?
Count({<UID= {"<CALENDAR_YEARWEEK_STRING ={">=$(=v_PeriodStar) <=$(=v_PeriodEnd)"}>"}>} distinct UID)
@Peony only this should work
Count({<CALENDAR_YEARWEEK_STRING ={">=$(v_PeriodStar) <=$(v_PeriodEnd)"}>} distinct UID)
Are you comparing UID with Calendar? try this? (PS, = can be removed if that is defined already in variable)
Count({<UID=P({<CALENDAR_YEARWEEK_STRING={">=$(=v_PeriodStar)<=$(=v_PeriodEnd)"}>} UID)>} distinct UID)
@Peony only this should work
Count({<CALENDAR_YEARWEEK_STRING ={">=$(v_PeriodStar) <=$(v_PeriodEnd)"}>} distinct UID)
@Kushal_Chawda Indeed! Too many quotes I set. Thank you!
@Anil_Babu_Samineni Thank you! Possible values set makes expression works