cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrejaar Frequent Visitor
Frequent Visitor

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: QoQ Calculation total problem

@andrejaar,

 

You may try a similar way as shown here.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
andrejaar Frequent Visitor
Frequent Visitor

QoQ calculation (And myself) going crazy

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 

 

PBI Image

 

Community Support Team
Community Support Team

Re: QoQ Calculation total problem

@andrejaar,

 

You may try a similar way as shown here.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.