psulions83
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 126
Hi,
I have a query that I am building where I have a calculated field (within the query) that I want to use to calculate a final value in another column. I cannot get this to work using to columns first would be the first calculation then the second would be the simple math equation. See below for example.
<tbody>
</tbody>
Hopefully the above makes sense. Do I have to perform an update query with cell C first then run another update query with cell D?
Right now I have tried to change data type from Short Text to Number. I continuously return no results for column D
I have a query that I am building where I have a calculated field (within the query) that I want to use to calculate a final value in another column. I cannot get this to work using to columns first would be the first calculation then the second would be the simple math equation. See below for example.
A | B | C | D |
100 | 2% | = Cell B / 100 | = Cell A * (1 - Cell C) |
<tbody>
</tbody>
Hopefully the above makes sense. Do I have to perform an update query with cell C first then run another update query with cell D?
Right now I have tried to change data type from Short Text to Number. I continuously return no results for column D
Last edited: