QUANTRIX 2018

If function does not extend across years

Join the discussion on using Formulas and Functions in Quantrix

Moderator: Moderators

If function does not extend across years

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

Hello,
I am trying to allocate value “0” in HC-Database Forecast matrix to items in category “Last,First”, who have entered some termination date in matrix Active HC-Budget.
E,g Abc was terminated in 8/17/17 and Xyz was terminated in 3/16/18.

PROBLEM: I can see a 0 against Abc in September in the Year 2017 but it does not extend to 2018. Need 0 against Abc in 2018.

My formula
In Fcst, Month = if(isblank('Active HC -Budget'::Termination),1,if('Active HC -Budget'::Termination<Date Manager::Date,0,1))

What am I missing?

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

How to extend zeros across years

Postby S a u » Sun Feb 18, 2018 3:34 am

Hi,

This is my version of the solution to your problem.
You do not have the required permissions to view the files attached to this post.
Best regards,
SAU
S a u
Quantrix Forum Member
 
Posts: 49
Joined: Fri Jun 20, 2014 8:57 am

Re: If function does not extend across years

Postby ShriShank » Mon Feb 19, 2018 9:37 am

Thank you for the reply.
Solution works but I cannot change the year to "2018" .... I have to keep it as FY18.
ShriShank
Quantrix Forum Member
 
Posts: 36
Joined: Mon Feb 13, 2017 9:25 am

How to extend zeros across years

Postby S a u » Mon Feb 19, 2018 10:21 am

Hi,

This model uses item names in the format you want.
You do not have the required permissions to view the files attached to this post.
Best regards,
SAU
S a u
Quantrix Forum Member
 
Posts: 49
Joined: Fri Jun 20, 2014 8:57 am


Return to Formulas and Functions

Who is online

Users browsing this forum: No registered users and 0 guests