Hello -

I have a multi-occ form that is display only where all the fields are displayed directly from a table except one that I am calculating. This field displays correctly if there is only one record. If there is more than one then the value for the last time the field is calculated is displayed for every record.

I hope I've explained this clearly. I need to have the calculated field display per record not the last record's value for all. I've attached an example pic.

Thanks,
tnzabo

First, make sure the field is defined as 'Display' on the form.

In the source code, specify as follows:


field.price.difference:
before.display:
price.difference = invoice.amount - order.amount

You know, sometimes simple is better. :)

Thanks so much. I was calculating in my select - works great!

tnzabo