cancel
Showing results for
Did you mean:
Highlighted
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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: QoQ Calculation total problem

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

Community Support Team

## Re: QoQ Calculation total problem

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.