smmvpwjen | Answers

Generic selectors
Exact matches only
Search title only
Search in content
Answers
Questions

Solved. In the attached model. reference: http://www.quantrix.com/help_resources/ ... ations.htm Thanks

View Question
1 Vote Selected

Cheers Rich, I have emailed you more details. Thank you once again.

View Question
0 Votes

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...

View Question
0 Votes

Solution: E1= select(@Budget Line Item::B Lineitem;@Budget Line Item::B Lineitem;@Actual Line Item::A LineItem) https://www.youtube.com/watch?v=d47v3l6Z_L4

View Question
0 Votes Selected

Thank you for the reply. Solution works but I cannot change the year to "2018" .... I have to keep it as FY18.

View Question
0 Votes

,y quick fix: Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,switch(@Year="2018",1,@Year="2019",13,@Year="2020",25,@Year="2021","37",1,),#Year:Month))...

View Question
0 Votes

When is use the following formula: Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,1,#Year:Month)) skip Better Worse,%// using Layoutof Analysis::Year as Year I can get the summation of actual wrt...

View Question
0 Votes

Thanks for the reply. But my aim with this model is to get the sum of the revenue(Year to date) from the starting fiscal year month of Oct to the month selected from the drop down menu in the category...

View Question
0 Votes
Load more answers