KnotKnick
03/24/2022, 2:03 PMGeorge McMullen
03/24/2022, 4:13 PMCASE WHEN {fieldname} != TRUNC({fieldname}) THEN 1 ELSE 0 END
And then set the criteria for 1. The conversion to integer using TRUNC might not work all the time, but you could also try TO_NUMBER or CAST.KnotKnick
03/24/2022, 5:03 PM