4.44E-16 Calculation Error

[Anonymous]

Dear Community,

within a measure that compares one value (current week) with an other value (previuos week) I´m getting an confuse error showing a value "4.44E-16".

Opening that data point as a table it´s correctly shown as 0.0.

Could anyone help to understand where this is coming from?

Thanks for your support,

Alex

[amitchandak]

@Anonymous , If the data format of measure/column is scientific then make it decimal and check

[Anonymous]

Thanks @amitchandak ,

value is already set as decimal number.

Error is the same, showing already 4.44E-16

BR, Alex

[Tahreem24]

@Anonymous ,

Could you please share some sample data so we can test at our side. If possible to Just share the Prev and Current Values of the error row.

[Anonymous]

Hi @Tahreem24 

I could but that makes no sense, both are "0".

I have removed the measure from the table and put back in, now it´s showing correctly.

Any ideas? Don´t want to do this step every week...

Maybe it´s something within the measure thats calculating across 4 different files (?)

Best regards, Alex

[Tahreem24]

@Anonymous ,

Handle your division with IFERROR.

Measure = IFERROR(Prev/Current,0)

SO when there is any error like infinity in division so it will execute the second parameter means 0.

[Anonymous]

Thanks @Tahreem24 

don´t know if this will fix my issue cause it´s already in the measure...

Let´s see how it works next week.

Thanks for now!

Regards,

Alex