# Sum Number to another Number from a Look Up Not Working! **URL:** \ **Category:** Ask for Help\ **Created:** [March 4, 2022, 2:06am UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221 "2022-03-04T02:06:19Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\ **Post date:** [March 4, 2022, 2:06am UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221/1 "2022-03-04T02:06:19Z")
Hi Everyone! I’m doing a Look Up from another table and adding to an existing number, but the results is rare. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c5a984f0ed9bbec6c471cc94efab858044da305.png) Any clue?? **What Went Wrong ??** ---
**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:** [March 4, 2022, 2:40am UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221/2 "2022-03-04T02:40:12Z")
What are the formulas in those columns? How do the numbers differ from what you would expect? Do you expect the values in the Total column to be the same as the values in the Difference column? You probably need to apply a math round or trunc function to one or more of your formulas. ---
**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\ **Post date:** [March 4, 2022, 12:28pm UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221/3 "2022-03-04T12:28:29Z")
Hi Darren! Thnx for your fast answer! **Total** (Math) **Price x Qty** both num format columns. **Paid** (Look Up) is an amount from other table, num format column. **Difference** (Math) is determined by subtracting **Paid** from **Total**. **Total - Paid**. `As you can see in last row` , looks like **Difference** is **Total - 1** Am I right? ---
**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\ **Post date:** [March 4, 2022, 12:37pm UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221/4 "2022-03-04T12:37:31Z")
Solved!! 2 Columns, same name, different amounts. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 5, 2022, 12:38pm UTC](https://community.glideapps.com/t/sum-number-to-another-number-from-a-look-up-not-working/39221/5 "2022-03-05T12:38:23Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.