Forum Discussion

erikbeauch's avatar
erikbeauch
Frequent Visitor
2 years ago
Solved

Multiplying two measures and losing all decimals

Hi, in the example below, I have measures from a transaction history table. Quantity is the sum of all share quantities in the history table.  Avg price is the sum of all costs (Quantity * Paid pri...
  • erikbeauch's avatar
    2 years ago

    It actually started working by rounding the two sub measures like this:

    Mes_AvgPrice = ROUND([Mes_Cost]/[Mes_Qty],5)