summarising specific values within a data set

[#1]

Looking for some advice on how to achieve the following.

I have data loaded that contains a number of attributes. 1 being Business Rule Type.

I can get the summary of associated values using the expression below

     Sum ({<[Business Rule Type]={'EBR'}>}[Passing Rows])

What I want to do is extend this further to take into account another criteria/

ie. The summary of Passing rows for (Business Rule Type = EBR and Business Rule Name = Null)

Reasoning is I wish to categorise the TYPES into other areas...

Regards

Robin

[stephencredmond · Accepted solution]

Hi Robin,

You can use the -={} construct in the set to exclude nulls:

=Sum ({<[Business Rule Type]={'EBR'}, [Business Rule Name]-={}>}[Passing Rows])

Note that the -= may show as a syntax error but it is not.

Regards,

Stephen

[#3]

Thanks Stephen, appreciate the support