Hi,
in a formula calling only time-distributed variables with same categories, why it is not possible to sum each category separatedly using the “all” time modifier option?
For example:
Consider v1, v2, v3 and v4 with values distributed along a year and having categories A and B.
Why its prohibited to write: "(v1{cat:all}{time:all}+v2{cat:all}{time:all}+v3{cat:all}{time:all})/v4{cat:all}{time:all} "? I would expect to have as a result a variable inheriting the categories from the formula, with “A” and “B” having absolute values from the sum of the v1, v2, v3 and v4 across the year by selecting “{time:all}”. But this is not possible.
I was expecting to use the categories “power” to concisely write a formula expression that, at the same time, does math operations and transforms time spanned variables in absolute values of a sum of each category item separately.
One way to do what I want is creating new sum-up variables from the time-spanned result of using {time:current} instead of {time: all} in the previous example. But I wonder why I couldn’t do that more elegantly.
Thanks in advance for any tip on that!