asked on July 13, 2023
Tell me, where can I get a description of the syntax and all available functions in the field where I create a new Calculated value?
Here is a list that is not complete:
https://www.flexmonster.com/question/full-list-of-supported-operators-for-calculated-values-formula/
For example, the possibility of writing the blank() function in the formula is not mentioned.
Thank you.
⋅ July 14, 2023
Hello, Pallich!
Thank you for reaching out to us.
Kindly note that you can find the list of all available formulas for calculated values in our documentation: https://www.flexmonster.com/doc/calculated-values/#formula-operators.
However, there is no blank() formula defined for calculated values. Could you please provide us with more details about this case? Is there any example where such a formula is implemented?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ July 19, 2023
Exemple:
if(sum(value) >0, sum(value), blank())
⋅ July 21, 2023
Hello, Pallich!
Thank you for getting back to us.
Kindly note that the blank() function returns NULL in the provided calculated value formula, as such a function doesn't exist. Therefore, Flexmonster formats null values as "blank" strings on the grid(which can be configured via formatting).
This behavior is reproducible only if the Flexmonster formulas validator is turned off. With the validator enabled, you will get the "Wrong formula format" alert message.
Please check the validator is enabled in your report:
report: {
//other report configurations
options: {
validateFormulas: true
//other options
}
}
If the report doesn't contain validateFormulas property, that means it is enabled by default.
Hope you will find our answers helpful.
Feel free to contact us if you have any further questions.
Kind regards,
Solomiia
⋅ August 1, 2023
Hello, Pallich!
Hope you are doing well.
Our team is wondering if you had some time to check our previous response. Could you please let us know if there are any further questions?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ August 9, 2023
Hello, Pallich!
Hope you are having a great week.
Just checking in to ask if you have any further questions regarding Flexmonster calculated values formulas.
Please, do not hesitate to reach out to us in case of any questions.
Kind regards,
Solomiia