Hello@neg177,

You could achieve it still using the movingsum. But do not use the parameter Average.

Sum and divide by the count.

Using if condition, sum only the weekdays (skip the weekends).

XX-Y03 Securitization (Actuals) = if weekend then 0 else Y03 Securitization (Actuals)

For eg, if the current day is monday, your moving sum should be

Average = MOVINGSUM('XX-Y03 Securitization (Actuals)'.Portfolio Factor Rate, -6, 0, SUM) / 6

But you divide it by 6, so you will skip the weekend and calculate your average.

希望它可以帮助。

Thanks

Arun