Thanks @keme1 and @mariosv!
@keme1, as I understand from your suggestion I’d still have to replicate the formula for the condition term, is that right? The idea would be not needing to replicate the “value” formula just for inserting it into a condition.
I could make it work with something similar to @mariosv 's suggestion, but there’s the issue of CURRENT()'s output being volatile and changing along the formula, as you mentioned.
This is how I did it:
About the CURRENT’s volatility issue, that makes it especially hard to use this result within other functions, within the same formula. But I figured its result is resetted each time it’s used inside as nested function, as in below:
This returns “28”, since the second CURRENT will output “14”, the result from the whole preceding formula. But if you nest the second CURRENT’s usage within another function, this is what you get:
This returns “18”, that is, the second CURRENT outputs “4”, instead of “14”, which means it’s resetted when used from inside a different function.
I think by using this workaround we could elaborate to create even more complex formulas, without needing to repeat the expression. It may become a bit convoluted for sure, but I thik it might still be better than repeating “complex” formulas in more places than needed, until we have a better solution.