~ exclude how it will work in expression

[Karim_Khan]

HI Team,

I wanted to exclude the Sales level 2  value from my Expression but its not working.

=sum({$<~[Sales Level 2]={$(vSel2)},[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 1]={$(vSel1)}>} [Net Bookings])

Regards,

KK

[sasiparupudi1]

hi

the - syntax will show the expression in red but the expression should work fine as long as it is showing expression ok message

hth

Sasi

[jonathandienst]

Qv versions prior to 11.20 SR11 incorrectly flag the -= as an error, but it is valid syntax and it should work.  Your use of the ~ was not valid syntax.

If it still does not work, then tell us how vSel1 and vSel2 are defined as these could be causing the error.

[Karim_Khan]

ok got it

[Karim_Khan]

ok got it