Hi, jlin, As far as I understood you, your model should calculate: 1. A shift the list of initial data by the quarters and by years (by means of the valueat()); 2. The sums of data by years (YTDs). I provide...
View Question
sau | Answers
sau 130 Rep.
Hi Walker, If you wonder how to use the select() function for solving your problem, then try to use the following formula: Name = select( Super Bowl Squares::; @Super Bowl Squares::Broncos:Seahawks; Scores::Broncos:Last...
View Question Hi all. I also met this problem when I tested QM5.1 in January 2014. Empirically I found a solution by using the one formula. In your case the formula looks like this: [SIZE="2"][font="Lucida Console"]Cumulated...
View Question Hi Denis, Most likely, you have to clear an excel data from unprintable characters before importing into QM operation.
View Question In the models you shouldn't mix different levels of calculations in one matrix. If you define calculations on lower specification level, don't add in this matrix aggregation on upper specification level....
View Question Hi, Try the attached model file. Note. It is necessary to distinguish [b:7eahjuok]count[/b:7eahjuok]() and [b:7eahjuok]countA[/b:7eahjuok]() functions.
View Question When will be released QM5.1 CashFlow can be calculated by using ValueAT() function: Cashflow = ValueAt( Revenue:Month, #Month - Assumption Input::Value:Cashflow Month Offset ) So wait for QM5.1 release
View Question