Hello community
I have an 'if' statement that is giving me hell, i need your help.
We have the following fields:
[Boys]
[Girls]
[#No]
[Children]
The [Children ] can have >1 [#No].
The original expression is :
((sum([Boys])-sum([Girls]))* 0.90)-avg([Boys])
Now the 'if ' statement is supposed to be something like:
If ([#No]>1,((sum([Boys])-sum([Girls]))* 0.90)-avg([Boys]),(((sum([Boys])* 0.90)-avg([Boys])))
Dimension [Children]
Some how im getting the wrong answer when [Children] has only 1 [#No]
Please help.
