Skip to Content
avatar image
Former Member

Excluding Negative Transaction

Hi all,

I am trying to create a variable to count all transaction where retail sale is 0.

I am using this formual to create a variable Transaction

=If[Retail Sale]>0 Then Count([Tran Seq No])Else 0

This work fine if I am putting this variable with transaction like

store Sales transaction_no transaction

But if I remove the transaction_no dimension from the result the Transaction formula is

not working and it is calculating -ve transaction also. Please help me to count only +ve Sales transaction

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers