QUANTRIX 2018

Unable to extract data wrt Month from Two different Matrix

Join the discussion on using Formulas and Functions in Quantrix

Moderator: Moderators

Unable to extract data wrt Month from Two different Matrix

Postby ShriShank » Sun Feb 25, 2018 3:28 pm

Hello,
I am trying to extract Expected Salary data from matrix TBH PLan based on the month indicated in Start Date column. I end up extracting the data during the month selected in the first row of matrix TBH Plan.
What formula should i use to move the cursor along the dept and also along month or Start Date column.

I want to show 50k in August and 45K in March for Corporate and 75k in development during the month of April for development in AvgSalEx matrix.
My formula:
Month=if(#Month=TBH Plan::MnPos,Sum(select(TBH Plan::Expected Salary,@level(TBH Plan::DeptS, 1),@Dept)),0)
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: Unable to extract data wrt Month from Two different Matr

Postby S a u » Mon Feb 26, 2018 8:46 am

Hi,

Apply an example of model in which the result necessary to you is manually written down
Best regards,
SAU
S a u
Quantrix Forum Member
 
Posts: 49
Joined: Fri Jun 20, 2014 8:57 am

Re: Unable to extract data wrt Month from Two different Matr

Postby ShriShank » Mon Feb 26, 2018 9:52 am

The requirement matrix has the manual input.
My final goal is to be able to fill the AvgSalExp with Monthly salary of people hired . E.g for Corporate dept the average salary starts with (50k/12)=4166 during Feb to which (45k/12) is added during the month of March and the total salary is continued till the year end.

As of now I couldnot even pull the salary wrt to date and year correctly. Stuck on first step. :( :confused:
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: Unable to extract data wrt Month from Two different Matr

Postby S a u » Mon Feb 26, 2018 10:35 am

Do examine this model. Is it what you need?
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: Unable to extract data wrt Month from Two different Matr

Postby ShriShank » Tue Feb 27, 2018 10:30 am

Thanks this works!
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