4 Replies Latest reply on Apr 4, 2012 9:50 AM by Emily Mueller

    Paramater result of calculated field

    Emily Mueller

      I have a paramater set up for a workbook that I am working on.  However I cannot create a paramater result calculation with a calculated measure that I created.   I'm assuming there is some kind of workaround for this. 

       

      My calculated field is called Processed per day:

      sum(p1delwt)/countd(date)

       

      My paramater is year, so I am trying to create the following paramater calculation:

      If(Year)=Year Paramater then Processed per day end

       

      I get the error message "cannot mix aggregate and non-aggregate comparisons in 'IF' expressions, so it won't allow me to create the calculated field.

      My paramater calculation to return p1delwt works.

       

      I have attached a copy of the workbook. Any help would be greatly appreciated.

       

      Thanks!