Filter for columns with x.5

[df]

Hi

i want to creat a formular which gives every number with x.5 a Y and without "." a N

how can i do this?

RecordID (Input)		Filter (Output)
1		N
1.5		Y
2		N
2.5		Y
3		N
3.5		Y

[LordNeilLord · Accepted solution]

Hey @df

You can do something like:

If [Record] != FLOOR([Record]) Then "Y" Else "N" Endif