ssepan1 | Answers

SteveB I had seen that popup on the Category link, but hadn't thought about it. Yes, a popup on the formula (each) would do nicely for quick access. The only gotcha is that the tooltip disappears after...

John, So, if I understand what you're suggesting, the ability to have 'summary-like' functions, but to have finer control over 1) which items in a category are included, and 2) what operation is...

SteveB Good point about the name -- a well-named function can go further toward clarity than a lot of details. This especially true for well known algorithms in a given industry, when the algorithms...

SteveB Yes, a hint of that thought occured to me after I had posted the PS about the summary formula. It would certainly be a way to accomplish a similar result by leveraging the existing code in QM....

PS - I am pleased to note that the Summation formula IS automatically copied to the matrices into which the Category is linked. This closely mimics the linking of formulas that I mentioned, except that...

(...continuing separately, because I seem to have hit the Enter Key prematurely) Perhaps I should have come up with an example other than a simple Sum, because the contents of the formula is really...

Mike, Yes, I see that, and if I want summaries it would certainly make more sense to use that than do it manually like I did in the first version of the model.

To follow up... The choice of the categories Reps, Regions, or Products in the classes.model is really irrelevant and was made arbitrarily. The key thing is that the 2 matrices aren't related except...

Yup -- I missed that one. Here's another one worth noting: "Subx Inc in Portland will use their award for research and development to design and implement the Data Services Module (DSM) for their flagship...