Expression

[adiarnon]

hi,

I want to count the number of projects that

Sum(budget)>0

and

Sum(budget)<100

and

age>20

tnx adi

[PrashantSangle]

Hi,

Try like this

count(if(Sum(budget)>0 and Sum(budget)<100 and age>20,Projects)

Regards

[tresesco]

Front-end? May be like:

=Count(If(Aggr(Sum(budget), Dimension)>0 and

               Aggr(Sum(budget), Dimension)<100 and

               age>20,Dimension))

[jagan]

Hi Adi,

Try like this

Sum(Aggr(if(Sum(budget)>0 and Sum(budget)<100 and age>20, 1),Projects))

Hope this helps you.

Regards,

Jagan.

[adiarnon]

hi tnx!!!

can i do that with a set analysis?

[jagan · Accepted solution]

Hi,

Try like this

=Count({<Projects={" =Sum(budget)>0 and Sum(budget)<100"}, Age={'>20'}>} DISTINCT Projects)

Regards,

Jagan.

[adiarnon]

hi,

tnx!

i will try this.

i didnt knew that i can use 'and' in set analysis...

[adiarnon]

its not working   =(

any other soluitions?

[tresesco]

Could you create a sample qvw and share here?

[jonathandienst]

Hi

The set analysis method will not work in a table or chart where the sum(budget) or age may differ from row to row, as the set expression is calculated once for the whole table, not once per row.

HTH

Jonathan