Remove negative 0 from explorer.

[Former Member]

Hello,

I have created explorer based on query where every fiscal year's actual value is 0.00, but when I use this query in explorer some fiscal year's actual value is -0.00.Can you please tell me why is this showing this weird behavior.For reference I have attached screen shot.Please have look into it and suggest some solution.

Thanks,

Urmil Kansara.

[former_member376301]

Hi,

This issue is due to the double/float computing.

When double or float are not processed with IEEE 754 standard, we could have -0.00, 0.00.

In the same scope, when you compute 0.1+0.1+0.1 result is not equals to 0.3 ??!!

Regards,