nested aggregation not allowed

[agni_gold]

Hi Friends,

(sum({<[Planning Versions]={"$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}>}

[Sales Plan in KS]*(if(ASP=0 and PLC=6.2 , Max(PMIN),ASP))))

is there any alternative?

[Anil_Babu_Samineni]

Looks like better approach only, try this?

(sum({<[Planning Versions]={"$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}>}

[Sales Plan in KS])*sum({<ASP = {0}, PLC ={'6.2'}, PMI={'$(=max(PMI))'}>}ASP))

[agni_gold]

sum({<ASP = {0}, PLC ={'6.2'}, PMI={'$(=max(PMI))'}>}ASP))

and

if(ASP=0 and PLC=6.2 , Max(PMIN),ASP))

are same?

[agni_gold]

gwassenaar‌  , any help, please.

[Anil_Babu_Samineni]

I've notice now. Two are not the same and this condition works as same when you apply max statement in first expression then you may get answer. Let's wait sunny response stalwar1‌

[vishsaggi]

Try this may be:

= sum({<

                [Planning Versions] = { "$(=Right(Year(Today()),1)&Num(vG_FN_CurrentMonth-1,'00'))"}

           >}  [Sales Plan in KS]

           ) * if(ASP = 0 and PLC = 6.2 , Max(PMIN), ASP)

[agni_gold]

will it do row by row multiplication?

[vishsaggi]

Did you try, it should. What chart object are you using?