cumlative

[Thijs_Qlik]

Hi al,

i am trying to make a cumulative model where the time above the capacity line is added to the next week is there anyone who can help me with this?

variable:

Total time
Total time plus 10%
Capacity

what we have so far:

what i want to get:

[Oliver_F]

not completely sure if this will work out, but are you aware of the above() function?

you can try sth like: yourKPI + maxrange(above(yourKPI) - capacity,0)