— The Forums are now read-only —
— All new activity now takes place here: —
Is it possible to multiply two of my data fields, that are already in my results grid, together to make its own data field?
I'm not aware of a way to reference the results of one calculated column in another calculated column. Therefore you have to repeat the calculation.
Example:
Column A: =a+b
Column B: =x+y
Column C: (a+b) * (x+y)
Shawn's way is the only way that I'm aware of as well.
I would say that it would be a nice feature to have, but I'm not sure it would be that simple since everything gets translated into a SQL query and SQL has the same problem unless you start using variables to store results which complicates the SQL statement.
By using this website, you agree to our Terms of Use (click here)
