different conditions

[#1]

Hi!

is anyone know

in theory ...why it't the same?

sum( if(aggr(sum({<bg_t={'*'} >}Quantity),AffiliateID,Holding,mes,mes_a )>0
and mes = mes_a
,1,0))

works

sum(if(aggr(sum({<bg_t={'*'}}, mes = mes_a >}Quantity),AffiliateID,Holding,mes,mes_a )>0 ,1,0))

not works

[perumal_41]

Hi ,

Try this expression

sum(if(aggr(sum({<bg_t={'*'}}, mes = p(mes_a) >}Quantity),AffiliateID,Holding,mes,mes_a )>0 ,1,0))

[#3]

Hi! thank you for help.  result stil not for each row:

country	mes_a	sum( if(aggr(sum({<bg_t={'*'} >}Quantity),AffiliateID,Holding,mes,mes_a )>0 and mes = mes_a ,1,0))	sum(if(aggr(sum({<bg_t={'*'}, mes = p(mes_a) >}Quantity),AffiliateID,Holding,mes,mes_a )>0 ,1,0))
England	201201	313	1004
England	201202	328	1004
England	201203	363	1004