Does Forms have a Multiplication formula? I did not see one in the Administration Guide.
I'm trying to insert a multiplication formula in my total column.
column 1 value X column 2 value = total
Thanks. Pete
Yes, it is PRODUCT(). For example, PRODUCT(Field1,Field2)
EDIT: If you're using multiple rows in a table, you'll also need to use INDEX(table.column,ROW()) to specify that you only want the column value for the current row.
Jason,
Thank you for the information! It worked!
Thanks again,
Pete
Jason,
Would you please elaborate on the use of the "INDEX"? The PRODUCT formula worked, but when I add a row, it gets screwed up. Does the INDEX formula fit inside the PRODUCT formula?
You would need to wrap the INDEX function around each variable.
For example
INDEX(Table.Column1,ROW())
would isolate the column 1 variable for the same row as the field that has the function.
If you are using the PRODUCT function, you will need to put INDEX around each individual variable
For example,
PRODUCT(INDEX(Table.Column1,ROW()),INDEX(Table.Column2,ROW()))
So if you put this into column 3, it would only use the column 1 and column 2 values from the same row.
Jason,
My original PRODUCT formula looked like "=PRODUCT(Item_s_.Quantity_1, Item_s_.Price_each)."
I'm wanting my calculation in column 5 to be the product of the values in columns 3 ("Quantity") and 4 ("Price per item") of the same row. Thus, my column 5 calculation looks like: "=PRODUCT(INDEX(Table.Column3,Row()), INDEX(Table.Column4,Row()))."
I'm assuming I need to incorporate some elements from my original PRODUCT formula into my PRODUCT(INDEX) formula because the current formula isn't working.
You need to replace the "Table.Column" values with the actual variables.
For example, your original has Item_s_.Quantity_1 and Item_s_.Price_each, which seem to be the values that should be inside the index function.
Thank you so much, Jason! I actually managed to figure it out on my own about 20 minutes ago, but forgot to update you. I appreciate the reply!
Glad you got it figured out!