How to multiply two fields within a dynamic table.

Avatar

Avatar

Fratos9

Avatar

Fratos9

Fratos9

04-09-2015

Untitled.jpgI have set up a table that has 9 colums, as follows:

What I would like to do, within the 'Amount Ex INT' box (Contained within a separate subform),

is to Total the 'Hours' * 'Rate for each separate instance/row.

within the Total field I have used FormCalc to workout the total of (Hours * Rate) * INT% / 100.

This works fine within the row and gives the total of my rate plus interest.

Then for the Grand Total I have just used $.rawValue = sum($.Table.Table1.Row1[*].Total.rawValue)

however, it isn't as simple as adding the entirety of column 'Rate' together, adding the entirety of column 'Hours' together

and then multiplying them by one another.

I need to be able to inject each Row instance (Hours * Rate) into a variable and then add all occurrences of that variable together.

...or something similar and less complicated.

Thanks for your time.

Kind Regards,

Dan.

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

ali83mousa

Avatar

ali83mousa

ali83mousa

30-03-2016

I know this has been posted for a while, but I found exactly what you need on this URL:

http://forms.stefcameron.com/2009/02/25/expandable-table-with-totals/