Forum Discussion
erikbeauch
2 years agoFrequent Visitor
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...
- 2 years ago
It actually started working by rounding the two sub measures like this:
Mes_AvgPrice = ROUND([Mes_Cost]/[Mes_Qty],5)
erikbeauch
2 years agoFrequent Visitor
It actually started working by rounding the two sub measures like this:
Mes_AvgPrice = ROUND([Mes_Cost]/[Mes_Qty],5)