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

    Sum of value from Date to Period



      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?