Error with not equal to in expression @ pivot table

[#1]

Hi,

In pivot table, I'm trying to write the following expression

SUM({<[Cyence User Status] <> {'Disabled'}>}[Cyence Credit Approval Limit]) , but the system says error in modifier. But when I write,

SUM({<[Cyence User Status] = {'Disabled'}>}[Cyence Credit Approval Limit])

it works fine.

Can someone please help me with not equal to expression.

Thank you in advance.

Regards,

Adi

[ramoncova06 · Accepted solution]

SUM({<[Cyence User Status] -= {'Disabled'}>}[Cyence Credit Approval Limit])

the <> does not work in the set analysis use "-=" instead

[#3]

Thanks Ramon!!!