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.
have you checked if the expression works?
Hi,
Can you attach the sample file.
Regards,
jagan.
Hi Jagan Moan
Unfortunately I cannot attach the sample file.
I think the problem could be that i must put the 'sum' before the 'if' in the expression....
Hi Michael
Im getting a syntax error
what kind of value are in the field children?
numbes 1 to 30
The second expressiion seems to be working Michael. I just want to verify this and I'll let you know
have you checked if the expression works?