Restrict value with set analysis and OR clause

[#1]

Hello,

I have the following expression:

=Count({<[Actual Volume]={'>0'}>}%SKU)

This counts SKUs for which there is sales Volume.

I want to add in an OR statement in my set analysis that accounts for production volume

=Count({<[Production Volume]={'>0'}>}%SKU)

How would I combine these two, so that SKUs are counted if there is either sales or production volume?

Thank you

Mel

[cesaraccardi · Accepted solution]

Hi Mel,

You can use the set operator for union ( + ) to achieve that:

=Count({$<[Actual Volume]={'>0'}>+$<[Production Volume]={'>0'}>}%SKU)

Kind Regards,

Cesar

[#3]

Hi

Count({<[Actual Volume]={'>0'}>+<[Production Volume]={'>0'}>}%SKU)

Should work for you

hope that helps

Joe