Improving the readability of formulas through the formula’s variables

1

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 allow an optional section with the definition of formula’s variables according to this scheme:
*
[‘ – the opening tag of the formula’s variables definition section;
Set Variables: $a = definition of the variable ‘a‘ through the QM functions;
…………………..$b = definition of the variable ‘b‘ using the QM function;
……………………………………………………………………………………….;
…………………..$n = definition of the variable ‘n‘ through the QM functions;
]‘ – the closing tag of the formula’s variables definition section.
*
Now, let’s look at the imaginary application of theĀ formula’s variables in the formula from this forum.

*

Pay attention to how much easier it became to read If() logic. Imagine that you need to slightly to change the parameters of Select() – you will only do this once.
*
It would be interesting to hear your feedback on this proposal, so please speak out.

Answered question
0

That is a very good idea. But I am not sure if my customers (especially not advanced) would find it easier (or say intuitive) to write formulas when they first should set variables (it looks a bit like programming).

Answered question
You are viewing 1 out of 9 answers, click here to view all answers.