I’m trying to filter even/whole dollar amounts for an analytic. There is a way to filter on increments of 25 or 50? Any help/guidance would be great. Thanks!
Solved! Go to Solution.
You can use the mod function. It provdies you with a remainder, so you can divide by 25. Anything that is not a multiple of 25 will fall out.
Place this in the "Custom Filter" Option within the filter:
IF(MOD([Field1],25)>=1)
THEN 'FALSE'
ELSE 'TRUE'
ENDIF
Thanks! But I'm still having problems with the MOD working. I copied it into the custom filters window and change [Field1] to the [Signed Amount]. However, it isn't filtering out amounts that are multiples of 25 that are greater than zero. I placed browsers on both the 'T' and 'F' output and i still have a mixed of data.
Andrew's suggestion should work so sounds like you need to troubleshoot. Use a formula tool and create the experssion Mod([Field1], 25). See the results of this against your data and see if you're getting what is expected - i.e. the number 50 should return 0 and 109 should return 9.