Adding Null Values to Set Analysis

[tcyw2910]

Hi all,

currently, I am using the formula below to try meet 2 criteria's:

=count({<[Global Orders Flag]={"Ireland/UK"},[Order Ref]={"=IsNull([Customer Name]) or [Customer Name] <> 'Customer1'"}>}distinct([Order Ref]))

1. count of order references that are from Ireland/UK and not from Customer1, but also include any null values in Customer Name.
2. include orders that are not from Customer1 but have a Null value for Global Orders Flag

I have been able to get the first point sorted, however I am not sure what to change/add to the formula to get it to include data that have a null value under Global Orders Flag? I want it to extract data whilst meeting both criteria's. 

Thanks,

Kind regards,
Terence

[GaryGiles]

Try using the "+" between two <set definitions> to union the 2 sets.  Something like:

=count({<[Global Orders Flag]={"Ireland/UK"},[Order Ref]={"=IsNull([Customer Name]) or [Customer Name] <> 'Customer1'"}>+<[Order Ref]={"=(IsNull([Global Orders Flag]) and (IsNull([Customer Name]) or [Customer Name] <> 'Customer1'))"}>}distinct([Order Ref]))