Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
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)