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)
Your idea has been added to our backlog. We are now further investigating the idea.
You can do this with a database trigger fairly easily.