Sep 08, 2019 06:00 AM
I am trying to make a grocery list that would take the price of an item ($0.88) and multiply it by the quantity needed (2) so that it outputs the total amount ($1.76)
I have tried the formula Price * Quantity which hasn’t worked.
How would i create a formula to output the total price as stated above?
Solved! Go to Solution.
Sep 08, 2019 09:27 AM
Sep 08, 2019 06:39 AM
HI.
What error do you have?
It should work.
Look at your field types:
it should be number or currency for prices, and number for quantity.
Sep 08, 2019 09:21 AM
Price is set as a currency field and Quantity is set as a numeric field.
when i input the formula
Price * Quantity
the formula outputs an integer when i am expecting a currency
Sep 08, 2019 09:26 AM
Change the “formating” in airtable formula field to “currency”
Sep 08, 2019 09:27 AM
Sep 08, 2019 09:48 PM
That worked, Thank you