2 Replies Latest reply on Oct 3, 2012 4:08 AM by sreekanth.upputuri

    Calculation help required on if aggregate and non aggregate values

    sreekanth.upputuri

      Hi Experts ,

       

      I am working on calculation thing in my work sheet  the calculation are below like this

       

      I have created one “Boolean parameter variable” name it is : [ $ or % Achievement]

      Boolian para.png

       

      I am using this Parameter in my  IF statement it not working . it giving the error like this

       

      “ Cannot mix Aggregate and non-aggregate  in If Expertion “

       

      My IF statement is :

       

      “IF  [$ or % Achievement] THEN  100* Sum([CLOSED_PIPELINE_AMOUNT])/Total(sum([QUOTA_AMOUNT])) ELSE  [CLOSED_PIPELINE_AMOUNT]  END”