BITAND...

[#1]

In SET analysis, can I use BITAND like this or is my syntax wrong?   In the example below the Project Status is an integer value which can be 1,2,4,8,16,32 or 64

SUM({<ProjectStatus BITAND 48 >= {"48"}>}METRIC_COMPLETED)

Thanks in advance...

Syd

[JonnyPoole]

I don't believe so , but i'm not sure which values (1,2,4,8,16,32,64)  you expect to bring back from this SET expression.  Can you elaborate what the intended filter would result in ?

[Gysbert_Wassenaar]

No, only a field name can be used on the left hand side. You'd have to use something like this instead:

SUM({<ProjectStatus= {"=ProjectStatus BITAND 48 >= 48"}>}METRIC_COMPLETED)