I am trying to equate the subsequent months to zero in matrix HC- Database Forecast based on termination date selected in Active HC- Budget.
Feb .. Sep = case(@|||Type-HC||| = "Fcst",@Month=month(|||Active HC -Budget|||::Termination,"Jan"),@Month = 0,1)
but I get invalid recurrence along month error.
So, For Abc I want Mar through Sep to be zero. How do I do that?