houle | Answers

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

The attached file shows how to do this simple addition. Matrix1 does it with an "item-based" formula: B3 = B1 + B2 and Matrix2 does it with a "cell-based" formula: C2:D5 = C2:D3 + C2:D4 Note that...

View Question
1 Vote Selected

If you have two or more categories in the row or column tray you can use select/shift/select to collapse a specific instance of an item or range of items. In the attached example I have used this technique...

View Question
1 Vote Selected

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes

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

View Question
0 Votes
Load more answers