Solved. In the attached model. reference: http://www.quantrix.com/help_resources/ ... ations.htm Thanks
View Question
smmvpwjen | Answers
smmvpwjen 102 Rep.
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 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 Thank you for the reply. Solution works but I cannot change the year to "2018" .... I have to keep it as FY18.
View Question ,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 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 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