Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Questions
houle 215 Rep.

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

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

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

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

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

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