9 Replies Latest reply: Mar 4, 2015 12:16 AM by Amit Saini RSS

    YTD Help???

    Amit Saini

      Hi Folks ,

       

      I'm having expression as below:

       

      if(sum([Act Planned Production Hours]) = 0, avg([Act OEE]),
      sum([Act OEE]*[Act Planned Production Hours])/sum([Act Planned Production Hours]))

       

       

      Need to calculate YTD from this . Any suggestions???

       

       

      Thanks,

      AS