Hello!
My question is, is it possible to somehow create my own global function that can then be called on different columns without duplicating code?
Let’s say this formula is saved somewhere
WITH checkSign = (num):
IF (num > 0):
"+"
ELSE:
"-"
And then in different columns when using formulas, I can simply write one line checkSing(100)
Hello @Alex
It is possible to create a formula column, save it and then use it in any structure (as in add the column to a view of the structure). However, referencing a formula in another formula is possible only if the referenced formula is present as a column in the same structure. You can also create the formula inside a formula by mapping a formula's variable to the Formula option, and configuring an additional formula there. An outside formula can't be tied to a variable.
I hope this helps. If you have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.
Best regards,
Stepan
Tempo (the Structure app vendor)
@Stepan Kholodov _Tempo_ thank u for answer!
Unfortunately, this is not what I need. If I refer to another formula, I get its value, but I wanted to avoid duplicating the code when I conditionally calculate for 12 months the same value with a change in one parameter.
Are you planning to implement something like this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alex
No particular plans so far. But we'll be glad to talk more with you about your use-case if you want to share it.
Please reach out to us directly and we'll go from there.
Best regards,
Stepan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.