Skip to main content
Participant
December 1, 2017
Question

How to add multiple items and multiply it - need help with Javascript

  • December 1, 2017
  • 1 reply
  • 393 views

I would like to add about 3 columns and multiply them by another column and I'm having some problems writing the javascript.

I would like to add totals with the following headings:

Hotel1+Parking1+Mileage1*USexchange1 .

Could someone provide me with the instructions?

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
December 1, 2017

Just add parentheses and put the exact formula above under the Simple Field Notation option in the Calculate tab.

You don't need JS.

Participant
December 1, 2017

Could you give me an example?

try67
Community Expert
Community Expert
December 1, 2017

(Hotel1+Parking1+Mileage1) * USexchange1