Convert negative number value

[#1]

Hi,

How do we do for converting negative number? i have some value like -1.78967*******e-16, i want this to be displayed either as 0 or some number with just 2 decimals (like -1.78f). I tried using the above function. But it doesn't work. Thanks in advance.

Thanks & Regards

Priyanka

[#2]

Hi

Directory;

LOAD Id,

     Value,

     Round(Value,'10') as Result

FROM

Its Working

[Anil_Babu_Samineni]

I am not sure, How your real data seems, But practice it should work

LOAD If(SubStringCount(Wellcome,'e'),0,Wellcome) as Wellcome Inline [

Wellcome

-1.78967********e-16

-0.28

-0.31

-1.00

];

[adamdavi3s]

e-16 means 10 to the power -16 i.e. 16 zeros before the number

[adamdavi3s]

You might also want to check if 'supress zero values' is switched on as this will stop the exponent value showing if Qlik sees it as 0

[#6]

Hello All,

Thanks everyone for your answers. It worked by using the 'Round' function. Thanks @adam davies

Have a nice day

Thanks & Regards

Priyanka