QUANTRIX 2018

Invalid Error for Month

Join the discussion on using Formulas and Functions in Quantrix

Moderator: Moderators

Invalid Error for Month

Postby ShriShank » Fri Feb 16, 2018 6:40 pm

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
You do not have the required permissions to view the files attached to this post.
ShriShank
Quantrix Forum Member
 
Posts: 36
Joined: Mon Feb 13, 2017 9:25 am

Re: Invalid Error for Month

Postby S a u » Sat Feb 17, 2018 2:26 am

Hi,

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)
Best regards,
SAU
S a u
Quantrix Forum Member
 
Posts: 49
Joined: Fri Jun 20, 2014 8:57 am

Re: Invalid Error for Month

Postby ShriShank » Sat Feb 17, 2018 11:11 pm

Works....Thanks
ShriShank
Quantrix Forum Member
 
Posts: 36
Joined: Mon Feb 13, 2017 9:25 am


Return to Formulas and Functions

Who is online

Users browsing this forum: No registered users and 0 guests