1 Reply Latest reply: Jun 22, 2011 7:52 AM by Erica de+Boer RSS

    Sum of value from Date to Period

      Hello,

       

      I have made this expression :

      sum (if(EmpDate <= Date, if(OutofEmp = '31-12-2099',  Contracturen)))/40

       

      It then shows the Contracturen for every day in a given period. But when I remove Date from the Dimension in my Pivot table the Contracturen from all the days are summed up. So instead of displaying 39,75 it shows 1007,3.

       

      How can I make it possible to show 39,75 for a period?