Forum Discussion

hitesh160790's avatar
hitesh160790
Frequent Visitor
6 years ago
Solved

Multiplication issue 4th Decimal

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

Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

3 Replies

    • hitesh160790's avatar
      hitesh160790
      Frequent Visitor
      6 years ago

      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.
       
  • Icey's avatar
    Icey
    Community Support
    6 years ago

    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.