Capturing an specific value in your data

[ll98]

I'm looking just to write a formula where I can capture just the salaries that end in .50.   

Employees	Salaries
Lenn	7800.50
Bob	7800.51
Smith	5000.50
Taylor	500.49

[AngelosPachis]

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

[messi007]

@ll98,

As it's a number I have done a simple workflow to keep values with .5

Below the workflow, hope this helps:

Regards,

[ll98]

Thanks .. and if I have other columns with the same criteria.... 

[AngelosPachis]

@ll98 

It depends on how you want your output to look like. The simplest answer is to bring everything into a single column (through transpose) then  apply the formula/filter and then cross-tab to bring the table to it original form. The values in the same record which don't meet the criteria will be null.

[SeanAdams]

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'