By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
3
Users
0
Reactions
3,585
Views
May 23, 2018 3:02 pm
Is it possible to multiply two of my data fields, that are already in my results grid, together to make its own data field?
2 Replies
May 23, 2018 3:41 pm
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)
June 4, 2018 12:52 pm
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.