Forum Discussion
QoQ Calculation total problem
Hi Pbi Friends,
Having problem with 1 messure... it shows data correct, but total not so good.
Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master
Basically i need to know :
( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )
Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"
Atual = Current Quarter Av. Price
Ultimo = LastQuarter Av. Price
Qtde = Quantity
https://i.imgur.com/I8URAdT.png
2 Replies
- andrejaarFrequent Visitor
Hi Pbi Friends,
Having problem with 1 messure... it shows data correct, but total not so good.
Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master
Basically i need to know :
( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )
Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"
Atual = Current Quarter Av. Price
Ultimo = LastQuarter Av. Price
Qtde = Quantity
https://i.imgur.com/I8URAdT.png
- v-chuncz-msftCommunity Support