The Sum is Incorrect

[rafaelr08]

Power Bi is summing the values incorrectly. The values should be equal to zero but its showing a balance of 0.000000000000185 instead of zero as seen in the images below. 

and now showing two decimal places. 

Aug-21 and the amounts are in the same table. It still shows this error no matter what data type i choose. Im trying to filter out balances that are zero or less, so this is messing up my visual/matrix. 

[Anonymous]

Hi @rafaelr08 ,

If you choose the Sum in Values, the value of the total is to add up all the values above you. If the above rows add up to 0, then the total returns 0.

If you choose for Min or Max, the totals will return the smallest or largest values of all the rows above instead of adding them up.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Vinod_P]

Go to format your visual --> Visual --> Specific column  --> apply settings to  select the column and set the value decimal places to 2