Community
Connect with us and enhance your M-Files experience using Extension Kit for M-Files. Here is how to get started.

Is there a way in Property Calculations to use a formula? I'm looking to use a formula that includes multiplication and division for multiple properties into one property. I'm only seeing that you could do one or the other.
Thanks,
Jeff
Hi @jwittkopf,
The only module where you can currently configure a formula is the Extended Auto Properties module. Within this module, you can use math expression parsers and build nested formulas, similar to the example below:
Please note, however, that this approach works only if all the metadata required for the calculation is located on the same object. If your calculation involves parent-child relationships or references to other objects, this method will not work.
In such cases, the only way to perform multiple mathematical operations is by using temporary properties to store intermediate results. Although the Property Calculation module is often used for mathematical operations, I recommend using the Property Operation module instead. It is more powerful and allows you to set multiple properties within a single rule, eliminating the need to create several separate rules for your formula.
Best regards,
Nika
