Invalid Error for Month

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved1.01K viewsFormulas and Functions
0

Hello,
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?

Thanks

Selected answer as best
1

Hi,

Keep the item [b:4vwwwdkp]|||Active HC -Budget|||::Termination[/b:4vwwwdkp] is completely filled with dates and try this formula:

[color=#000080:4vwwwdkp]Fcst = If(#Month > Match(Month(|||Active HC -Budget|||::Termination; "Jan");@Month; 0); 0; 1)[/color:4vwwwdkp]

Selected answer as best
0

Works….Thanks