Notifications
Clear all

[Solved] Property Calculations - Formulas

0
Topic starter

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


1 Answer
0

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:

 

image

 

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