Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Mel,
You can use the set operator for union ( + ) to achieve that:
=Count({$<[Actual Volume]={'>0'}>+$<[Production Volume]={'>0'}>}%SKU)
Kind Regards,
Cesar
Hi Mel,
You can use the set operator for union ( + ) to achieve that:
=Count({$<[Actual Volume]={'>0'}>+$<[Production Volume]={'>0'}>}%SKU)
Kind Regards,
Cesar
Hi
Count({<[Actual Volume]={'>0'}>+<[Production Volume]={'>0'}>}%SKU)
Should work for you
hope that helps
Joe