Greetings Forum Community,
What improvements and new features would you like to see in future versions of Quantrix? User feedback is an important piece of our product planning. Use this thread to let us know what we do well, what we can do a better job at and the new features you would like to see in the Quantrix application.
Hi. I am doing a tour de force auditing models developed by my students in the financial planning lab class. I have found that a lot of time is consumed with recurrence formulas along nested dimensions, e.g.
In year[FIRST]:month[FIRST], revenue = some input value
revenue = revenue:month[PREV] * growth rate
In month[FIRST], revenue = revenue:year[PREV]:month[LAST] * growth rate
Time is consumed because:
– you have to write at least three formulas
– this is a frequent cause of errors.
It would be great to have nested recursion, i.e. being able to write something like
revenue = revenue:[year:month][PREV] * growth rate
I have tried several tricks with select() and nested counters (#year:month) or even scripting, but didn’t found anything satisfactory.
I remember that this feature has already been requested by users.