S A U | Reputations

Received an upvote	April 6, 2021	10
Posted an answer How to sum a value range with more than one criteria Hi vb67! 1. Let there are three matrices: SD{C:Fields[I:Value, TypeP, P], C:Recs[I:Rc1..Rc10]} is some Source Data, SmlCrt{C:Criterium[I:TypeP, P]} is Sampling Criteria, Report{C:CalcVar[I:Calc1..Calc3]}...	April 2, 2021	5
Received an upvote	March 29, 2021	10
Received an upvote	March 29, 2021	10
Posted an answer Useful improvements of rank() function The problem solution is here. Good luck	March 26, 2021	5
Posted an answer Three rank types calculation in QM Here I am submitting unsorted data. As you can see, the calculations are correct in this case as well. * * Logic: * * *** Good luck	March 26, 2021	5
Asked a question Three rank types calculation in QM Hello everyone! Again, for those who appreciate the effectiveness of calculations in QM, I will show here a way to obtain three types of rank on sorted data (Useful improvements of rank() function). *...	March 26, 2021	2
Received an upvote 'Drop down menu' and number formats of binding cells 'Drop down menu' canvas's widget does not get number formats from the binding cells. This makes it impossible to use the 'Drop down menu' for error-free control of the model. I remember, QM4.1 easily took...	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables Tahir, the formula’s variables should be an optional feature, despite the fact that in the second picture it is written "AS IT SHOULD BE". Who wants to and to whom it is convenient, he will use the formula’s...	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables Addition. Here's how you could write this complicated formula using the formula's variables: * * I suggest to everyone to evaluate.	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula's variables If Subx team enter such an object as formula's variables in the QM, then the formulas will become much easier to write and read. For example, it could be implemented like this. The formula editor will...	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables Jlin, it would be interesting to look at your version of a possible implementation. Make a picture with your version of the above formula, we all compare the pros and cons of the two sentences.	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables FYI, Microsoft introduced similar functionality for Excel 2019 by means of the Let() function... But Subx development team within 1.5 years did not even respond to this offer. Excellent	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables jlin, In November 2015 I had requested Subx by email an option to set the formulas background color for QM6... Now it is already released QM8... So, for the reporting purposes i'm using 3rd party app converts...	March 25, 2021	10
Received an upvote Improving the readability of formulas through the formula’s variables For the exhibition only. See how clear the logic of the formula using the formula's variable is compared to the regular one. * * Is there anyone having an opinion on the topic? Or your models don't have...	March 25, 2021	10
Received an upvote Replacing 'Item Names' with 'Dynamic List' for the Generate Items module Hi, Subx team. It would be reasonable for you to replace the Item Names option in the Generate Items module with a similar Dynamic List option of the Constrain Input module. For what? - In order to generate...	March 25, 2021	10
Received an upvote Wrong calendar calculations The important addition. Calendar calculations were correct up to QM4.x.y. I am sure that the error was introduced due to the TimeLine module starting from QM5.x.y.	March 25, 2021	10
Received an upvote Wrong calendar calculations As is well known, the first week of 1900's date system is: * 1 = Sun; 2 = Mon; 3 = Tue; 4 = Wed; 5 = Thu; 6 = Fri; 7 = Sat. * With this in mind, let's create two copies of the drop-down list to select...	March 25, 2021	10
Received an upvote The histogram based on two svg-images Hi all, Based on the youtube channеl video of Smart Modeling Solutions I have created the dashboard part replica. Attached is the anime GIF file only. If anyone is interesting in how it to model let me...	March 25, 2021	10
Received an upvote The histogram based on two svg-images James, here is my model. It contains the minimal necessary explanations for matrices and their formulas. If you have questions on the model, I will try to answer. * Good luck	March 25, 2021	10