how to use P() E() functions with AND logic

[ziabobaz]

Hi!

I have Created, Sent, Cancelled statuses for each Order

I want to Count those orders, which were Created AND Cancelled, but never Sent

My formula:

Count(distinct {<Order = P ( {< Status ={'Created'} >}) + P ( {< Status ={'Cancelled'} ) - P ( {< Status ={'Sent'} >})  >} OrderN)

It does not work as intended. It seems that + between first two P() works as OR, not AND

Please, help.

[agigliotti · Accepted solution]

Hi @ziabobaz ,

Maybe this:

=Count(distinct {<Order = P ( {< Status ={'Created'} >}) * P ( {< Status ={'Cancelled'} ) - P ( {< Status ={'Sent'} >}) >} OrderN)

I hope it can helps.

Best Regards

[ziabobaz]

Yes, it works, many thanks!