Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Single row computation

Hi QV brains i need a help pls: I've to calculate   

sum(A * B) / sum(B)

where B is the price of  5 different products.

How can i do it

Tks

2 Replies
jaumecf23
Creator III
Creator III

Maybe this :

sum({<ProductID={'Product1','Product2','Product3','Product4','Product5'}>}Amount)

sunny_talwar

So, what is the problem... is this not working? sum(A * B) / sum(B)