houle | Answers

Doug/Chris, Another option for the formula to calculate a 3-month rolling average is to use "selectbetween" (Mike mentions this above). In the forecast model, that formula would look like this: Three...

George, This Modeler Note on the Quantrix web discusses use of the @ operator in a formula: [url:1hzupfej]http://www.quantrix.com/Leveraging_Operators.htm[/url:1hzupfej]. Chris

If you have more than two views opened as tabs and you click and drag one of the background tabs onto the foreground tab, it will combine the two into one tab. The names of the views will be separated...

Savvy, Good point. This would have been issue even if you had a two month delay, but it crossed a year end. Since you are already calculating Date in the Payment Schedule matrix, the better approach...

Savvy, Take a look at the attached. I've added a "Principal Payment" formula (#4). It begins in the appropriate month, uses the PMT() function to calculate the total payment, and then subtracts Interest...

I think these two formulas will do the trick: Bank ACCOUNT:Week[THIS] = ENDING CASH:Week[PREV] and Bank ACCOUNT:'1':Month[THIS] = ENDING CASH:'5':Month[PREV] [THIS] and [PREV] are part of how you implement...

Henry, I looks like you have exceeded a limit. You can reset this outside Quantrix by editing the file Quantrix Modeler.exe.vmoptions in the Quantrix program directory (usually C:Program FilesQuantrix...

You can return the label of an item in a category to a formula by using the operator @[Category Name]. If the item name is a number and you want to use the number in a calculation, you can convert the...