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?
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.
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.
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
Change the “formating” in airtable formula field to “currency”
That worked, Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.