I did a little more testing by adding a variable vAmount.
I put it to the right of my column Amount on the tiered form.
When I enter $10.00 in Amount, my vSubtotal = $10.00.
Then I move to the variable field and enter $10.00.
My cursor drops to the next row.
vSubtotal increases to $20.00,
the amount of the variable vAmount of $10.00 is shown
on line two without being entered (because the value was
not reset to null or zero, which could be done in an eep)
and the subtotal for my variable column = $30.00.
The subtotals should both equal $10.00.
I had a computed column in my table but removed it
and it had no effect.
Randy Peterson
Frank,
I don't think you need the eep.
Set a variable in the form to calculate your subtotal.
I tested a currency column called Amount.
Select Variable, Edit.
Then enter vSubtotal= Currency to establish a currency variable.
[Do not use the = sign, use a space]
(It will not show up as a variable). Then
vSubtotal = (.vSubtotal + Amount)
You need to initialize vSubtotal = 0 or set Zero on in order for the
variable to show on the form. When you open the form it will
show $0.00.
Locate the variable outside your tiered rows.
Each time you leave a row, the subtotal should update and show
correctly.
Actually my subtotal doubled the amount entered. So in order to
show correctly the formula was vSubtotal = (.vSubtotal + Amount /2)
Which seems totally unexplicable. But I am using RBWin 6.5+ ...
Could someone proffer a clue on why the entered amount might double?
