New to the forum, so go easy on me for this question; as I've tried looking around to the best of my ability.
In my report I have an invoice number field that is in string format. I'm looking to filter out all of these invoice numbers that do not end in 0. The logic I found below I used got rid of most of them, but there are some that are still showing up and I have no clue why:
if {INVOICE_NUM}[len({INVOICE_NUM})-1] = "0" then {INVOICE_NUM}
I would appreciate any help coming my way.
IP Logged
