SET ANALYSIS

[adiarnon]

HI,

I WANT TO COUNT PROJECTS THAT-

Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)}>}ActualCurrentBook),PROJECT)>0

AND

Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)}>}BudgetCurrentBook),PROJECT)>0)

HOW SHOULD I WRITE THE EXPRESSION?

[adiarnon]

?

[jyothish8807]

Hi Adi,

can you please let me know the condition you want to implement?

Regards

KC

[adiarnon]

I want to count the number of projects that

Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)}>}ActualCurrentBook)>0

and

Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)}>}BudgetCurrentBook)>0

[jyothish8807]

Hi Adi,

Is this you want?

Count({<[BUDGET VERSION]={'$(=vMaxBudgetVersion)'}>}Project)

Regards

KC

[anbu1984]

Count(If(Aggr(Sum({<[BUDGET VERSION]={$(vMaxBudgetVersion)}>}ActualCurrentBook),PROJECT)>0,PROJECT))