Skip to Content
avatar image
Former Member

Webi formula: Count of smaller values than average


I am beginner BO Web Intelligence and I'm still learning, sorry if I do some basic questions to you.

I'm doing a report that 4.1 BO Web Intelligence from a variable (which makes the average, made manually) it has to detect a table of values which are smaller than the average.

The formula of the average is:

     = Sum ([Body]) / Count ([num_of_week])

The average variable called "Average (var)".

And I want to add another column to indicate how many values are smaller than average.

I tried this:

     =Sum( If([Body]<[Average(var)];1;0))

But it shows only 0.

Could anyone help me out with this?

Thank you very much to all!

Capture.PNG (11.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2015 at 05:38 PM

    Hey Miquel,

    This is how I was able to achieve it.

    v_Avg_by_Month =Average([Body]) ForAll ([Month])

    v_Count_less_than_Avg = Sum(If([Body] < [v_Avg_by_Month]) Then 1 Else 0))

    Let me know if that helps.


    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded