Appearing "-1E-14" instead of 0

[Anonymous]

Hi There,
I want to know why appearing "-1E-14" instead of 0 in power bi

For Eg:
I had created a measure that returns "Qty Available = Qty Delivered - Qty Withdrawn"
for some records, if Qty Available = 0 then it shows as "-1E-14" instead of 0

[BA_Pete · Accepted solution]

Hi @Anonymous ,

It means that you have very small, fractional, values in either your [Qty Delivered] or [Qty Withdrawn] columns.

You can fix this by adjusting your measure slightly:

// EITHER THIS:

_Qty Available =
VAR __qtyAvail = [Qty Delivered] - [Qty Withdrawn]
RETURN
IF(__qtyAvail < 0.5, 0, __qtyAvail)

//OR THIS:

_Qty Available = ROUND([Qty Delivered] - [Qty Withdrawn], X) //where X is the decimal places that meets your needs

Obviously you can change the 0.5 condition or the decimal places argument to meet your own preferred tolerance.

You could also remedy this in Power Query using the Number.Round function on your column values.

Pete

[Anonymous]

Hi BA_Pete,
I found it as corrected, Thank you a lot for your prompt solution

Regards,
Rifdhy