Set Expression Help

[djfrear]

Hi,

I'm struggling to work out why this doesn't work as expected:

Count({<[IsDeleted]-={1},[IsAccepted]={1}>} [JobId-ID])

My intention is to count the JobId-ID field if "IsAccepted" is set to 1 but whilst ignoring anything where "IsDeleted" is set to

Could anyone help me as to what I'm just not understanding here? Logically it feels right, but the result does not change after adding the "IsDeleted" section

Regards, Daniel

[MindaugasBacius]

Count({<[IsDeleted],[IsAccepted]={1}>} [JobId-ID])

Try the above please.

In seat analysis to ignore the dimensions selection simply include it into the {<...>}.

[djfrear]

Thanks - that pointed me in the right direction. It's a data issue rather than a query issue!