How to propspread values on RPAS

Hello experts,

within RDF CE, we are calculating spread profiles at day level in a custom way. As a final step, in case of store closure for holidays, the profile must be renormalized, adding the contribution of the closing day(s) to the other days of the week, in a proportional way.

 

For example:

Mon Tue Wed Thu Fri Sat Sun

Calc Profile 0.15 0.05 0.05 0.1 0.15 0.25 0.25

Holiday X X

We need to re-distribute proportionally the contribution of Saturday+Sunday, thus 0.5, to the remainig days (mon-fri).

 

We tried this chain of rules (all measures at day_sku_store)

c_TempSpreadProf is the calculated profile, regardless of the holidays