10 Replies Latest reply: Sep 3, 2013 8:01 AM by Zama Phumla RSS

    complicated if statement

      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.