Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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]))
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