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 f...
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.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

hitesh160790 

Can you do it with a measure instead?

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

 

  • 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.