Help

Re: Multiplying price / quantity

Solved
Jump to Solution
933 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Caleb_Dicks
4 - Data Explorer
4 - Data Explorer

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?

Screenshots

1 Solution

Accepted Solutions
SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator
5 Replies 5
SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

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

Screenshots

SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

Change the “formating” in airtable formula field to “currency”

SDOK_Blog
6 - Interface Innovator
6 - Interface Innovator

Screenshot%20from%202019-09-08%2018-27-06

That worked, Thank you