Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

minus from cumulative

Hello all,   I’ve been struggling all day on this and can’t find a solution. I’m trying to work out how many workers my factory needs in the future.  I have a total each week that we need, [Weeks ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have made a cumulative Colum of the Work which needs doing:

Cummulative work =

(CALCULATE([Weeks backlog efficiency Zoned]    ,

    FILTER(ALL('Future Orders'[Yearweek Backlog 2-5]),VALUE('Future Orders'[Yearweek Backlog 2-5]) <= VALUE(MAX('Future Orders'[Yearweek Backlog 2-5])))))

 

and the difference between the Labour we have and the Labour we need:

 

+/- staff = [Weeks backlog efficiency Zoned]-SUM('D Labour (2)'[Past Staff])

 

this sits nicely in each “Yearweek Backlog 2-5”.  now all I need is a cumulative total of the +/-staff but it doesn’t work :(