sum(aggr with if

[bartwelvaarts]

hello friends of the qlik comunntiy,

I want to calculate the following  measure only when the if statement is true

sum(aggr(sum(Amount * Price),Month,Article,color) * aggr(avg([percentage),Month,Article,color))

But i do not get the right result, I tried something like this

sum(aggr(if( value ='YES',

sum(aggr(sum(Amount * Price),Month,Article,color) * aggr(avg([percentage),Month,Article,color))),,Month,Article,color))

but this does not work correctly. Does someone have any suggestions?

[MayilVahanan]

Hi @bartwelvaarts 

may be try like below

sum(aggr(sum({<value ={'YES'}>}Amount * Price)* avg({<value ={'YES'}>}[percentage)),Month,Article,color))