Hi Walker, please find in the attachment a revised version of your model a formula for doing the lookup on two dimensions. I went for "using as", because it gives a cleaner formula, making good use of...
View Question
lerzegov | Answers
I am glad to report that the missing check mark issue referenced as the first point in my previous post in this thread is no longer there after upgrading OSX to Monterey 12.3.1. Such issue had been showing...
View QuestionHi S A U, I reproduced a very simple use case in the model linked here (could not attach it to the post, error "file type not allowed"). Please delete the year category in the P/L matrix => deleted...
View QuestionHi S a u, you improved a lot on my example both in the formulas and the presentation! Thanks for the very useful tips on chart formatting. Kind regards, Luca
View QuestionI have encountered the same problem as Carlo: in QM 5.1 Mac Osx, when printing a view, one loses format information, starting from font sizes different from the default. That's a big waste of time for...
View QuestionWhy don't you import the merged data into the 3rd matrix directly from the database via datalink? If both queries have the same structure, you can import both with a SQL statement [1st query] UNION [2nd...
View QuestionThanks, Ben, for your informative answer. From an end user's point of view, I cannot grasp the relevance of the "sandboxing" choice. In traditional spreadsheets, scripting allows one to do many things...
View QuestionMike - As far as I can understand, the issue may involves some complex technical aspects. In order to focus, I have a question for your colleague: how could a script suppress the use of paginated data...
View QuestionJanak: the scripting API has a Model class and a Quantrix class which provides more than adequate functionality for creating, saving and switching between models. In another post, I pointed to the fact...
View QuestionHi Mike. I share J Scott's view. Checking problems may slow down recalculation, data import AND script execution when there is some innocuous imperfection in a model. I enclose a model with a script named...
View Question