on 10-22-2015 4:53 PM
Hi,
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!
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.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.