Error in Total

[nevilledhamsiri]

Dear All!

Please see the data arranged & I have got the latest three Months Average but the total seems to be in correct. I have applied aggr function to correct this but looks like an error in that. Hope some one will help me on this. The formula used given below as an attachment together with excel.

Regds

Neville

[pradosh_thakur]

Hi Neville

Try this

if (dimensionality()=0,sum(your avg expression) ,your_avg expression) in the expression.Make sure you have not suppressed the nulls. It may be the cause you have data mismatch.If this doesn't work than please post what are the dimension and what are the expressions you are using .

[nevilledhamsiri]

Hi Pradosh,

I have got the correct total through aggar function but wish to understand about the formula you suggested. Same I have applied but produce error. For your reference total P/T is attached.

Regds

Neville

[pradosh_thakur · Accepted solution]

for total row dimesnionalty =0 , so sum the averages  if dimensionality is zero or else just the average.

[nevilledhamsiri]

Dear Pradosh,

Thanks for your time to help me on the issue highlighted

Regds

Neville