Data Validation

Question

Hi,

Please suggest me a workflow from the following data:-

1) Sample Data

Roll NumberPercentageResult10.78 285 30.66 452

50.66

2) Condition:

I want to check the "Percentage" field is in a correct format (for eg. 0.23, 0.25, 0.66, etc.)

and the result as error or success should be stored in Result column.

Please suggest me solution.

Thanks

joshuaburkhow · Accepted Answer

Hi @vijaylnyadav

There are probably about 100 ways to do this but I would say one would be to check if the number is > 1 and < 0 using the formula tool.

Emil_Kos · Accepted Answer

Hi @vijaylnyadav,

Not sure what is the best way to identify if this is a valid percentage.

I have decided to go with checking if the column contains a dot. If it has it is a percentage. If not the result column will be null.

Please mark my post a solution if this was helpful.