Another Formula Question (AREV Specific)
At 28 JUN 1998 10:11:33PM danshane@mail.westco.net wrote:
Trying to do some math calculations on a symbolic field based on entries in multivalued fields.
1. Grand Total is symbolic getting its initial amount
from another non multivalued field.2. I have a multivalued field, Amount of Payment.
I can get it to subtract the first entry in the multi-
valued field, but nothing after that. Any help will be
GREATLY appreciated!
At 29 JUN 1998 02:43AM Curt Putnam wrote:
Your question is not really specific as to what you want done.
I assume you are familiar with the mv operators (+++ — / ***) and the reuse function. If not, try them. Either way, being a little more specific about your data structures and intentions will help. </QUOTE> —- === At 30 JUN 1998 12:52AM Dan Shane wrote: === <QUOTE>No, I am not familiar with the reuse function. I am familiar with the multivalued math operators. I have a database that has a field entitled Grand Total. This amount is entered manually. Then this amount is transferred to a field entitled, Balance Due. Balance Due is a symbolic field that gets its initial entry from the Grand Total field. Below the Balance Due field, I have a multivalued field entitled Payments. I wish to subtract the amounts entered in the multivalued field, Payments, subtracted from the Balance Due field, thereby updating the Balance Due field to reflect how much money is owed. I am new to Advanced Revelation. I've only had it about three weeks. </QUOTE> —- === At 30 JUN 1998 06:57AM Richard A. Wilson wrote: === <QUOTE>you can use the following formula in the dictionary to calculate BALANCE DUE @ANS=GRAND.TOTAL - SUM(PAYMENTS) you will need to correct the above to match your true dictionary items </QUOTE> View this thread on the forum...