On the Cancellations aggregate model, can you try giving it an aggregate function (e.g. AVG of AvgCancel…).
If that doesn’t work, try re-querying the MonthlyActiveClients model when the page loads (you can do this with a tab initial load action for example).
Lastly, if that doesn’t work, try wrapping your formula in VALUE(xxxx) functions. It should be VALUE(xxx)/VALUE(MODEL_LOOKUP(xxx)).
