Replacing values above/below certain criteria

[AlexAlbro12]

Hello,

In the workflow below, I am trying to replace values in the ETR and CashETR fields as follows:

- values below 0 should be reset to 0

- values above 1 should be reset to 1

These values need to be replaced in the FALSE section of the very last Filter tool.

I've tried using IF/ELSEIF and IIF formulas, but they don't seem to be working... I'm not quite sure how to make it work with FindReplace, it doesn't seem like I can set the parameters I need with that tool.

I think the data type may be the issue for ETR and CashETR, but if it changes, I need these fields to keep the same number of decimals for future calculations that need to be made with the Summarize tool.

Any help would be appreciated, thanks!

[CarliE]

Hi @AlexAlbro12!

Happy Friday. The reason you may be having issues, is because the data type is a string value. What I ended up doing was change the data type to a double and then apply the calculation.

Attached is the workbook.

Please mark this as a solution if this solved your problem to help other members on the community out!

Best,