# Add Math Formula using data from different tables **URL:** \ **Category:** Ask for Help\ **Created:** [June 1, 2023, 8:21am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350 "2023-06-01T08:21:10Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Cerosilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cerosilva/32/59819_2.png) [@Cerosilva](https://community.glideapps.com/u/Cerosilva)\ **Post date:** [June 1, 2023, 8:21am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/1 "2023-06-01T08:21:10Z")
Hi, I have two tables, one for the Item Details and the other table for Fees. I’m trying to add a formula to calculate the total fees in the item details table by taking the cost and multiplying it to the Fee from the other table but i can’t get the option for that formula. I added the fees to the Item Details table using a Lookup column and the rate is getting pulled up from the fees table but it’s still not allowing me to input a math formula. Thanks in advance for the help ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 1, 2023, 8:36am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/2 "2023-06-01T08:36:51Z")
This should be quite straight forward, but could you please add a screen shot of the two tables so that I can get an accurate visualisation? ---
**Author:** ![Cerosilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cerosilva/32/59819_2.png) [@Cerosilva](https://community.glideapps.com/u/Cerosilva)\ **Post date:** [June 1, 2023, 9:01am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/3 "2023-06-01T09:01:52Z")
![Selection_127](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c35e62c77e6771e9a55ef411744d1fe6448f0f90.png) ![Selection_126](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/583e3952bae314f9038ec52f73d7e10d6a53abcb.png) This is the setup. Basically, i need to multiply Gross Purchase with the STT Rate in the Fees table and output the Result in the Purchase STT Column ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 1, 2023, 9:10am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/4 "2023-06-01T09:10:08Z")
Okay, I see. What you can do is replace your STT lookup column with a Single Value column. You will then be able to use the resultant value in your Math formula. This assumes that you will only ever have one row in your fees table, that is, the same fees will be applied to every row in your Share table. ---
**Author:** ![Cerosilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cerosilva/32/59819_2.png) [@Cerosilva](https://community.glideapps.com/u/Cerosilva)\ **Post date:** [June 1, 2023, 10:41am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/5 "2023-06-01T10:41:29Z")
Ok, sorry for this request but I can’t seem to find that SINGLE VALUE ![Selection_128](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f22d07c6e818f78a5f6500d26a67907ef988455a.png) option anywhere. Could you point me to any relevant document? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 1, 2023, 10:46am UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/6 "2023-06-01T10:46:50Z")
It’s a column type, so you’re searching in the wrong place. ![CleanShot 2023-06-01 at 18.45.54@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50de70b90a113c2aa9c2bef7d6a797aa53195566.png) > **[Glide • Single Value Column](https://www.glideapps.com/docs/reference/computed-columns/single-value-column)** > > Retrieve a single value from a column or relation. ---
**Author:** ![Cerosilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cerosilva/32/59819_2.png) [@Cerosilva](https://community.glideapps.com/u/Cerosilva)\ **Post date:** [June 1, 2023, 12:49pm UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/7 "2023-06-01T12:49:43Z")
Thanks for the assist. Mucho Gracias. I managed to get it working with your assistance. Cant thank you enough. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 1, 2023, 12:53pm UTC](https://community.glideapps.com/t/add-math-formula-using-data-from-different-tables/62350/8 "2023-06-01T12:53:36Z")
Excellent 👍 Let us know if you need help with anything else.