Skip to main content
Solved

How to apply calculation in GI/Report?


Forum|alt.badge.img
  • Semi-Pro II
  • 218 replies

Hello All,
I have been trying to add a calculation for the following scenario,
I have the Total Sales (25000) & Probability (75%) (an attribute). I would like to multiply the values of both the fields and display in the GI
 


 

Both these values are from the Project Quotes screen.
So I want to display the result as 25000*75% = 18750

Best answer by Harry

Yes @Chris Hackett ,

That’s what I did:

And gave me the correct results.

View original
Did this topic help you find an answer to your question?

4 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 195 replies
  • December 27, 2023

@Harry  You can use PX.Objects.PM.PMQuote table on Generic Inquiry.

for Total Sales, select CuryAmount and check the Attributes and Value ID for this attribute and choice selected. In my case I selected 0.75 for 75% which helps me with the calculation.

And this is how I add a field with calculation on my GI:

 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • December 27, 2023
hkabiri wrote:

@Harry  You can use PX.Objects.PM.PMQuote table on Generic Inquiry.

for Total Sales, select CuryAmount and check the Attributes and Value ID for this attribute and choice selected. In my case I selected 0.75 for 75% which helps me with the calculation.

And this is how I add a field with calculation on my GI:

 

Hey @hkabiri , thank you for your prompt response. 
 

But no result:
 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2624 replies
  • February 21, 2024

Hi @Harry were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • Answer
  • February 22, 2024

Yes @Chris Hackett ,

That’s what I did:

And gave me the correct results.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings