Sum of Negative and Positive Value

[francia]

The total should be 3.4 but it showing as 3.6. Im using this formula - Round(sum(Financials)/1000,0.01). Please help. Thank you.

1.1

2.4

(-0.1) 

[Vegar]

Try usin Fabs() 

Round(sum( fabs(Financials) )/1000,0.01)

[francia]

Hi Vegar! The amount has been updated to 3.8

[francia]

I find this weird. I checked in the table and the total is correct(3.4) but when i put it in a graph it is not (3.6).

[marcus_sommer]

You don't look on the total of the bar else to a  sub-total. I'm not sure if it's possible to integrate this information in this kind of chart. You may skip it here and providing this information in another way (if it's really important enough).