Accumulate with Cap

[qlikviewaf]

I have Capacity  , On hand , Backorder, Need, Saeftystock quantities.

1. For each period I Calculated the net need as (Capacity + On hand - Backorder - Need - SaeftyStock)
2. What has been calculated at point 1 , needs to be carried over through the periods, with a maximum cap driven by Saefty Stock (so the carry over amount cannot be more than saefty stock value )

• Here below i put all the measure  (Capacity , on hand , backorder , need , saefty stock) and i summarized by Available  and Need with the difference shown as NET
• On the Expected Carryover is what i expect to get from a formula
• On the Carryover i set the formula suggested, but is not working as expected

Do you mind to help me in understanding what i'm missing? Thank you!