Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

multiply fields not created yet

Avatar

Level 4

Hi,

in my attached example...I have a quantity and unit cost that need multiplied together to = the cost.

That cost should then be totaled for all the subrows and listed in the cost field of the header row.

I'm confused on how/where to add the multiplication script for the quantity and unit cost fields.

Any help is greatly appreciated!

0 Replies

Avatar

Level 4

I have an updated file now where the first row added under header 1 multiplies quantity x unit cost, but it doesn't multiply it if you add a second row.

Any ideas...?

Avatar

Level 3

This sample might help.  Don't remember who posted it previously, but it seems like just what you need.

Avatar

Level 4

hmmm...not sure.  In the example I posted, I have the first row multiplying correctly, but then once you get to adding the second row, it doesn't multiply?