Calculating the Grand Mean (mean of means) in Webi

building reports webintelligence
1

I need help creating a formula in Webi report to calculate the grand mean for a set of data.

Here is an example:

  1. Three locations where the same trial was conducted. Named “Location_ID”
  2. For each trial there are four different experiments. Named "Exp_ID "
  3. For each experiment at each location, there are a different number of observations made. Named “Observation”

See attachments for samples of data in both Excel and PDF format.
This formula is as close as I have been able to get, but it doesn’t work.
=Average([Observation] In ([Location_ID],[Exp_ID])) In [Location_ID]

Thanks for the help.
Book1.xls (27.0 KB)
Book1.pdf (41.0 KB)

MattW101 (BOB member since 2013-11-07)

2

Hi,
Welcome to BOBJ :smiley:

Create a variable and use it in crosstab body

AvgVar
=Average([Observation]) In ([Location_ID];[Exp_ID])

And just click on AvgVar and select Average function.

Prashu :india: (BOB member since 2005-08-17)

3

Hi. Thanks for the quick response and welcome into the user group.

I created the variable and used it in a crosstab, but I have not been able to calculate the grand mean. The variable calculates the simple mean (the mean of each observation) but not the grand mean.
It’s possible I could just be missing some of the basics here, as I have only been using Webi a few months.
Could you provide a bit more instructions or perhaps a screenshot from Webi with it working properly? Thanks!

MattW101 (BOB member since 2013-11-07)