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

    Calculation help required on if aggregate and non aggregate values


      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”