3

Calculate in a table

Sarah Palombo

Need to be able to calculate within a table i.e where each row has Cost | QTY| VAT | Total Cost

Also, when you have lots of rows in a table you don't want a seperate calculate field for each one !

in the example above you'd have

row1.

A = Cost | QTY|

B = (A) VAT

C = (A+B) =Total Cost

row2.

A = Cost | QTY|

B = (A) VAT

C = (A+B) =Total Cost

row3.

A = Cost | QTY|

B = (A) VAT

C = (A+B) =Total Cost

row4.

A = Cost | QTY|

B = (A) VAT

C = (A+B) =Total Cost

etc..

Activity

Newest

Oldest

C

Chris Jones

Yes, sorry +1 - very important, otherwise you end up not using tables and creating literally hundreds of fields.

Mike Emery

Thanks for posting, @Sarah Palombo