Question

How do I multiply?

Forms How To

Updated February 13, 2019

asked on February 13, 2019

Okay, this might be a dumb question but I am new.

I am trying to get two fields to multiply. These are separate fields and not part of a table.

I saw a couple of posts but they were trying to do it based on a table.

I have the Total Miles being populated based on a Table Total which works fine, but I am trying to multiply that by the value in the Mileage Rate field.

Here is my formula: =SUM(TotalMiles.val*MileageRate.val)

Thank you!

0 0

Answer

SELECTED ANSWER

replied on February 13, 2019

You need to use the exact variable names from your form.

When you're on the formula setup, click the > button instead of typing them manually to make sure they match.

0 0

Replies

replied on February 13, 2019

Instead of SUM you would use MULT(Value1,Value2), and the ".val" is not necessary because formulas already target the variable value.

For example,

=MULT(TotalMiles,MileageRate)

1 0

replied on February 13, 2019

Hi Jason,

I put that formula and it gives me an error.

I copied the formula from yours to mine. I verified everything was the same too.

Thank you!

0 0

SELECTED ANSWER

replied on February 13, 2019

You need to use the exact variable names from your form.

When you're on the formula setup, click the > button instead of typing them manually to make sure they match.

0 0

replied on February 13, 2019

Hi Jason,

Did I mention I was a newbie?

That worked! Thank you so much.

0 0

You are not allowed to follow up in this post.

Question

Question

How do I multiply?

Answer

Replies

Sign in to reply to this post.