# Mathematical calculation between guides
**URL:** https://community.glideapps.com/t/mathematical-calculation-between-guides/12048
**Category:** Ask for Help
**Created:** [July 6, 2020, 12:06pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048 "2020-07-06T12:06:09Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 6, 2020, 12:06pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/1 "2020-07-06T12:06:09Z")
Good morning folks, I need some help. I am unable to do a mathematical operation of subtraction between two tabs.
I have a sum in the “products” tab, and another sum in the “movement” tab.
I need to bring to the “products” tab the result of subtraction values of (products - movement).
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 6, 2020, 12:21pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/2 "2020-07-06T12:21:09Z")
Currently it doesn’t let you bring that back via a relation - lookup?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 6, 2020, 12:27pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/3 "2020-07-06T12:27:43Z")
Hello @ThinhDinh , thanks for the feedback.
So I am not able to make this relationship.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 6, 2020, 12:55pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/4 "2020-07-06T12:55:12Z")
So that column does not show up when you try to have a lookup via a single relation or is that something else?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 6, 2020, 1:06pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/5 "2020-07-06T13:06:43Z")
Yes that’s it she doesn’t show up
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 6, 2020, 1:16pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/6 "2020-07-06T13:16:35Z")
Can you try making a template column with the value being that rollup column and make a lookup again?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 6, 2020, 2:58pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/7 "2020-07-06T14:58:35Z")
unsuccessfully 😭
there is no way to do math between tabs, I would have to bring this column from the “moves” tab into the “products” tab and thus perform the calculation.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 6, 2020, 3:00pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/8 "2020-07-06T15:00:31Z")
Yeah is there any reason you did not go that way at first?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 6, 2020, 3:46pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/9 "2020-07-06T15:46:47Z")
I don’t know, would it have any relation due to the fact that this column was created from a relation, not a normal number?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 6, 2020, 5:45pm UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/10 "2020-07-06T17:45:21Z")
I’m not quite clear, are you able to create a relation from Producto to Movements? If so, I would think a relation and a rollup or lookup from the Movements sheet should give you the number. Does the value show up as an option in the math column then? If not, you could try to take the rollup or lookup value and add it to a template column. Then use the template column in your math column.
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 9, 2020, 1:38am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/11 "2020-07-09T01:38:17Z")
I was successful on the part.
To be able to bring through the relation by the product the value of the “movement” tab and make the calculation.
But now I need to do the same calculation for a different “move” tab in the row’s ID column and I can’t.
Can’t match Row ID columns? 🤔
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 9, 2020, 1:41am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/12 "2020-07-09T01:41:38Z")
Are these values on the same sheet?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 9, 2020, 1:43am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/13 "2020-07-09T01:43:51Z")
No, the values are in the “handling” tab I want to bring to the “products” tab
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 9, 2020, 1:45am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/14 "2020-07-09T01:45:05Z")
yes values, are in the spreadsheet
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 9, 2020, 1:46am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/15 "2020-07-09T01:46:25Z")
Row IDs in different sheets of course won’t match, right?
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [July 9, 2020, 1:48am UTC](https://community.glideapps.com/t/mathematical-calculation-between-guides/12048/16 "2020-07-09T01:48:03Z")
correct, are unique
here be the values in the tab
