RE: Why doesn’t this formula work to show multiple transaction types in saved search

Good day.  I am not understanding why the following formula works in my transaction saved search criteria:

(Formula Numeric) equals 1

CASE WHEN ({type} = ‘Item Receipt’ AND SUBSTR({appliedtotransaction},1,8) = ‘Transfer’) THEN 1 ELSE 0 END

 

But, when I do this, it only shows Cash sales and Invocies:

CASE

WHEN ({type} = ‘Item Receipt’ AND SUBSTR({appliedtotransaction},1,8) = ‘Transfer’) THEN 1

WHEN ({type} = ‘Invoice’ )THEN 1

WHEN ({type} = ‘Cash Sale’ )THEN 1

ELSE 0 END

 

This returns 900K rows.  When I sort by the type, it only shows Cash Sales and Invoices.  It doesn’t make sense that the Item receipt would no longer appear.  I don’t see any other filter that would prevent.

Any ideas?  Thanks!

M.

 

memariani Rookie Asked on November 16, 2022 in How To's.
Add Comment
3 Answers

Hi,

What’s the purpose of the filter? Are you only looking for Item Receipts for Transfer Orders?

Could you also remove the criteria and add Applied To Transaction to the columns. What does this show?

Thanks,

Chris

Intermediate Answered on November 17, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.