Skip to Content

Excluding Negative Transaction

Nov 02, 2016 at 11:30 AM


avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers