Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Dimension [Children]
Some how im getting the wrong answer when [Children] has only 1 [#No]
Please help.
Thank you Michael, It worked perfectly.