Is there a way to filter on even/whole dollar amounts (25, 50, 75, 100, 125, 150, 200)?

[mullinexm]

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!

[andrewdatakim · Accepted 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

[mullinexm]

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.

[AndrewW]

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.