Eliminate negative zero

[#1]

Hi,

When a value is rounded off to two decimals, -0.0001 is rounding of to -0.00 it should be 0.00.

When we round in excel, -0.0001 is rounded to 0.00 or 0. I need same result in qlik also.

[Gysbert_Wassenaar]

Use the round function: round(sum(b),0.01)

And if you want to display zero values then disable the Suppress Zero-Values option on the Presentation tab.