Conditional Calculation
Simple Calculated Fields are number-type properties whose values are not provided by the users, instead they are calculated from other fields based on the formula set for the calculation. Now the limitation on such calculated fields was that no filter could be applied on these fields and a limited dataset as desire was not possible.
To overcome this limitation, the Conditional Calculation is introduced. The applicable filter could be any properties of the object.
Click the App Settings icon and then select the Application Settings option.
Click the Conditional Calculation option in the panel.
Click the New Conditional Calculations button.
The Create Conditional Calculation window is displayed.
The main object/entity to be used in the calculation.
The Calculated Property of the main object. It must be formulated in the schema beforehand so that it can be used here.
The secondary object/entity to be used in the calculation.
Used to add another sub-object
Relevant Sub Object List to be used in the calculation. The list of the sub Object also needs to be created beforehand so that it can be used here.
Provide all the desired info and click the Save button.
The desired Conditional Calculation is created.
Logic and implementation of the above Conditional Calculation
The basic logic behind the above conditional calculation is to:
Show the order total for only those orders (linked with the product) who are in the Pending state.
Now if we take a look at the following image, the result of the conditional calculation is evident.
