Hi All,
i am struggling in this error "resulted in a string but the field is numeric use tonumber" despite the field type as Double in all previous SELECT tools, Also the formula is not provide me the required result, Appreciate your help pls
Hi @Mostafa_Anwar, you are facing this error because your second and third condition overlap . Try using the formula with below modification:
if [H1 Brands Ach.]<.85 then 0elseif [H1 Brands Ach.]>=.85 and [H1 Brands Ach.]<1.20 then 2736elseif [H1 Brands Ach.]>=1.20 then 32400 else 0 endif
If you want the data type for field "H1 Payout" to be numeric (double), remove the double quotes around the number at the end of each line of your IF statement.
Your IF statement sets values to String (identified by the double quotes), but you have the data type for the field set to Double.
Chris
remove the " Quotation mark from the formula
Hi @Mostafa_Anwar,
Can you please use the values without quotes as given below and likewise:
If [a]<85 then 0
Thanks for your respond, i have changed but still getting the same error as per the screenshot below
