complicated if statement

[#1]

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.

[jagan]

Hi,

Can you attach the sample file.

Regards,

jagan.

[michael_maeuser]

try this

If ([#No]>1,(sum([Boys])-sum([Girls]))* 0.90)-avg([Boys]),(((sum([Boys])* 0.90)-avg([Boys])))

[#4]

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....

[michael_maeuser]

sorry mistake

If ([#No]>1,(sum([Boys])-sum([Girls]))* 0.90-avg([Boys]),sum([Boys])* 0.90-avg([Boys]))

[#6]

Hi Michael

Im getting a syntax error

[michael_maeuser]

what kind of value are in the field children?

[#8]

numbes 1 to 30

[#9]

The second expressiion seems to be working Michael. I just want to verify this and I'll let you know

[michael_maeuser · Accepted solution]

have you checked if the expression works?