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:
But it shows only 0.
Could anyone help me out with this?
Thank you very much to all!