Formula Gives Result in text form

[Pushpendra_1]

Hi,

The below formula that I use gives me the result in text form.

Can I modify the same formula to get the result in number format?

Thanks,

IF tonumber([PPV Quantity])<0 THEN tonumber([PPV Quantity])*-1 elseif tonumber([PPV Quantity])>0 then tonumber([PPV Quantity])*1 else "0" endif

[benakesh]

Hi @Pushpendra_1 ,

Try  else  0   i.e   formula  results are numbers  for  all conditions .

[MarqueeCrew]

Else "0" should be:

Else 0

Then you should be able to type the field as numeric.

Cheers,

Mark

[Kenda · Accepted solution]

@Pushpendra_1 

Are you creating a new field in a Formula tool? If so, in the drop down, select one of the numeric types. Also, just delete the quotes around the 0 in the very last portion of your expression.

Hope this helps!