Wrong addition / 1-1 = -1

[reporting_neu]

Hi everyone,

I have the problem with some results. If I compare identical values, the value -0 appears instead of 0.

Example:
4,32 - 4,32 = -0

What can I do against it?

[Mario_ES]

Hello,

If is a sum of two fields maybe they aren't identical values. Most of the times there's a small reminder that you can not see because of the number format. To solve this specify a format pattern that includes a format to display negative numbers without the - sign. For example #.0;#.0

[reporting_neu]

Many thanks for your response.
I tried the following. Unfortunately it does not work.

Sum(Num([FO_OP.Sk_NotPayed], '#,#0')) - Sum(Num([FO_OP.Sk_Payed], '#,#0'))

or

Num(Sum([FO_OP.Sk_NotPayed]), '#,#0') - Num(Sum([FO_OP.Sk_Payed]), '#,#0')

or

Num(Num(Sum([FO_OP.Sk_NotPayed]), '#,#0') - Num(Sum([FO_OP.Sk_Payed]), '#,#0'), '#,#0')

The yellow marked field shows the value with formula. The field with the red border shows the value without a formula:

[mikaelsc · Accepted solution]

formatting a number will never change it's value; 

you should/could round, floor, ceil,... your values (eventually in your load script) , but ensure your rounding doesn't affect your (aggregated) results.

[reporting_neu]

Thank you. 

It works with Round(Value, 0.01).