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
Solved! Go to Solution.
Hi @Pushpendra_1 ,
Try else 0 i.e formula results are numbers for all conditions .
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!