Formula Gives Result in text form

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

Data Investigation

Accepted answers

Kenda

@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!

All comments

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

@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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703