Invalid Error for Month

Solved3.78K viewsFormulas and Functions

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)

Month= if(@Month=0,Month[NEXT]=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?


S A U Changed status to publish September 22, 2018

Keep the item ‘Active HC -Budget’::Termination is completely filled with dates and try this formula:
Fcst = If(#Month > Match(Month(‘Active HC -Budget’::Termination; “Jan”);@Month; 0); 0; 1)

S A U Edited answer September 22, 2018
You are viewing 1 out of 2 answers, click here to view all answers.