Need assistance with formula tool

Question

I have copied formula in .png file:

output column is Value Trimmed and data type is Double

if contains ([Value], "%") then [Value Trimmed]/100 else [Value Trimmed] endif

when Value=98.05% the above formula outputs 0.9805 as expected

however, when Value="N/A" the above formula outputs N/A as [Null]

how would I update the above to include N/A in the output when Value=N/A?

Thank you

Value Trimmed.png

binu_acs · Answer

@bh1789 You need to change the data type from double to String to include the 'N/A'

If Contains([Value], '%') Then [Value Trimmed] /100 
ElseIF [Value] = 'N/A' Then 'N/A'
Else [Value Trimmed]
EndIF

rzdodson · Answer

From the looks of it, you are attempting to work with Double and Strings within the same formula structure without the proper IsNubmer or IsString syntax.

Here is an example of how one can wrap the IsNumber function to perform the calculation on a string field where the data appears to be numeric.