Calculate Index Data using index field values
Be able to calculate fields by other fields index data. Example:
Invoice Amount: 36.00
Invoice Payment: 20.00
Then be able to put an equation in a field called:
Invoice Amount Due: =(Invoice Amount - Invoice Payment)
31
votes
![](https://secure.gravatar.com/avatar/9dfc0c0314dba53efc9f8ab0bf42608e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Thank you for your contribution!Your idea is available with version 7.8 from April 2023 onwards.
-
G BAS commented
Thanks to the dev' team : it's a great implementation !
-
Anonymous commented
You can do this with a database trigger fairly easily.