Aggr()

[dunnalahk123]

HI,

Can some one help me here .

i wrote a below expression

Num(Avg(Aggr(Avg([SVT GDC TAT NumValue]), [SVT GDC TAT ID])),'#,##0' )

but when i look at the numbers each project ID i am getting right number but when i do over all average its not getting it correct as per below snapshot

When i export to excel and checked overall average is 36.41 as per below snapshot but i am getting as 14.56 . any idea why ?

[jonathandienst]

Are the dimensions of your table include in the Aggr() function? It seems that the inner Aggr() is returning some zero values which are pulling the outer average down, and you may be suppressing the zeroes in that table. Try doing this in a text box to see whether you are getting that record numbers that you expect:

Count(Aggr(Avg([SVT GDC TAT NumValue]), [SVT GDC TAT ID]))

[dunnalahk123]

Hi Jonty,

Thank You for your response.

no still tis not working.

[dunnalahk123]

HI Jonty,

You are right . the projects where it is "0" is getting suppressed due to option checked in presentation tab "Suppress Zero values".

[dunnalahk123]

Hi Jonty,

You are right . the projects where it is "0" is getting suppressed due to option checked in presentation tab "Suppress Zero values".

is there a way to write expression to get "0" values

[Sue_Macaluso]

Is this referring to QlikView or Sense? I'd like to move it into the correct product forum. This one is typically for general discussion and moving it will get more people to see it in the product forum

[dunnalahk123]

HI,

It is For Qlikview.

Thank You.