Forum Discussion

andrejaar's avatar
andrejaar
Frequent Visitor
8 years ago
Solved

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

  • andrejaar's avatar
    andrejaar
    Frequent 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 

     

    PBI Image