How to multiply two fields within a dynamic table.

Avatar

Avatar
Level 1
Fratos9
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
Fratos9
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
Fratos9
Level 1

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
Level 1
ali83mousa
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
ali83mousa
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
ali83mousa
Level 1

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/