Can I have a sum total of the product of more than 1 pair of fields?

[Kicomen]

Looking for a script for the below function.

I'd like to have the Total be the sum of each of the 4 products of Interest Rate x Balance.

Thank you!

[try67]

What are the names of the fields involved?

[Kicomen]

These are the field names. As well as the total field name.

OwnedRow_1 x fill_131 (Interest Rate x Balance)

OwnedRow_2 x fill_132

OwnedRow_3 x fill_133

OwnedRow_4 x fill_134

Schedule D total (Sum of the above products)

[try67]

Under the Calculate tab of the total field, in the Simplified Field Notation option, enter:

(OwnedRow_1 * fill_131) + (OwnedRow_2 * fill_132) + (OwnedRow_3 * fill_133) + (OwnedRow_4 * fill_134)

[Kicomen]

You are awesome try67! However, it's still not working. Here are some screen shots of what I did. Let me know if I've made an error.

First, thee is the OwnedRow1_2 filed which is a %. I added scripts to make it work so that entering 10 didn't case it to display 1000%.

Then I added the simplified field notation you so kindly provided. But I'm not getting a total in the Schedule D total field. Am I doing something wrong?

[try67]

Check the JS Console for error messages.

[Kicomen]

This is what it shows

[try67]

That means that one (or more) of the field names you entered is invalid.

Keep in mind that JS is case-sensitive!

[Kicomen]

Doesn't look like anything is misspelled. Any other options?

[Kicomen]

Any chance you'd be willing to look at the whole 3 page document for me? Do you have a Patreon or anything? You've been SUPER helpful!

[try67]

Sure. You can email it to me to try6767 at gmail.com.