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:






      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.