Multiplication issue 4th Decimal

[hitesh160790]

In my query, I am multiplying 2 columns.

One of the rows has values:

Column A = 4.0797

Column B = 353

If we multiply we should get 1440.1341

But I am Getting 1440.1383, this is happening for each row generally the 3rd decimal point is coming wrong. I am not sure how to handle this scenario or fix it.

All columns have data type as Decimal and it shows 4 decimal points.

Thank you

Thank you

Hitesh

[Icey · Accepted solution]

Hi @hitesh160790 ,

Try to use ROUND to keep two decimal places. Then, the values of other decimal places will not affect subsequent calculations.

For example, 

Measure = SUM('Table'[Column1])*SUM('Table'[Column2])

Measure 2 = ROUND(SUM('Table'[Column1]),2)

Measure 3 = ROUND(SUM('Table'[Column2]),2)

Measure 4 = [Measure 2]*[Measure 3]

BTW, .pbix file attached.

Best Regards,

Icey

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

[jdbuchanan71]

@hitesh160790 

Can you do it with a measure instead?

Amount = SUMX( 'Table' , 'Table'[Column1] * 'Table'[Column2] )

 

[hitesh160790]

Thank you @jdbuchanan71 for replying. 

Actually columns are coming from 2 different tables:

I will give you the original multiplication: 

SUMX(PlannedRequirements,PlannedRequirements[Plan Buy])*SUMX(FinishedGoods,FinishedGoods[Component Qty Per Assembly]*(100/(100-FinishedGoods[Scrap Factor]))*FinishedGoods[Part Qty Per Assembly])

Column A > SUMX(PlannedRequirements,PlannedRequirements[Plan Buy]) = 353

Column B > SUMX(FinishedGoods,FinishedGoods[Component Qty Per Assembly]*(100/(100-FinishedGoods[Scrap Factor]))*FinishedGoods[Part Qty Per Assembly]) = 4.0797

Now if I multiply these two I am getting the wrong result for the 4th decimal point.