Need assistance with formula tool

[bh1789]

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

[rzdodson]

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.

[binuacs]

@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