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?