I'm looking just to write a formula where I can capture just the salaries that end in .50.
Hi @ll98 ,
A not very elegant way to go about it would be to round the salaries and then estimate the difference between the rounded value and the original one.
If that's equal to 0.5, then you want to capture that record, so that will fall out of the True output anchor
Let me know if that worked for you.
Regards,
Angelos
@ll98,
As it's a number I have done a simple workflow to keep values with .5
Below the workflow, hope this helps:
Thanks .. and if I have other columns with the same criteria....
a quicker way is to convert to string, and look for "0.50" on the end of the string.
A filter tool with the formula left([Salaries],3) = '.50'
