Need some assistance with AREV 3.12, I am new to AREV,

I am trying to come up with a formula to do mathematical

operations on a symbolic field. This field displays a

balance. I am using a multivalued field that contains

different amounts. I am trying to subtract the values

in the multivalued field from the symbolic field to keep

a running balance of money due. I can subtract the

first amount in the AMV field, but as soon as a second

entry is made in the AMV, I get a runtime error msg.

Any help is greatly appreciated. Remember, Im an

amateur.

IF I understand what you are trying to do. In your second symbolic where you want to calculate the current amount due, I'd try a SUM function on the multivalue column. Something like:

@ANS=SUM(multivalue_column) - {fist_symbolic}

You may want to reverse the two values, depending on what out come you want (positive or negative). Or you can the ASB() and/or the NEG() functions within the calculation.

Remember to use the {} (currly brackets) around the name of the first symbolic.  This tells the system to go to that symbolic and run it and put the result in this calculation in place of the call to the symbolic.

Also remember that the SUM() function will add the lowest delimeter to the next highest.  So if you have a multivalue that contains @VM (value marks) and @SVM (sub-value marks), a single SUM() will only add the @SVM values up to the level of the @VM level.  So if that was the case and you want a single you would use a double SUM() function.  Like "SUM(SUM(multivalue_column))" to get a single value.

I hope this helps,

Michael Slack

E-mail: [email protected]

View this thread on the forum...