Data Validation

[vijaylnyadav]

Hi,

Please suggest me a workflow from the following data:-

1) Sample Data

Roll Number	Percentage	Result
1	0.78
2	85
3	0.66
4	52
5	0.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 solution]

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. 

[marcusblackhill]

Hey @vijaylnyadav !

If your percentage can't be higher than 1, can use a simple formula testing that:

IIF(ToNumber([Percentage]) <=1,[Percentage] ,"ERROR")

Hope that helps

[Emil_Kos · Accepted solution]

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.