Skip to main content
Solved

How to apply calculation in GI/Report?

  • Dec 27, 2023 4:39 PM UTC
  • 4 replies
  • 587 views
  • Translate All

Forum|alt.badge.img

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

4 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Dec 27, 2023 5:44 PM UTC

@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:

 

Translate

Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • Dec 27, 2023 5:56 PM UTC

@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:
 

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Feb 21, 2024 11:27 PM UTC

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

Translate

Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • Answer
  • Feb 22, 2024 2:47 AM UTC

Yes @Chris Hackett ,

That’s what I did:

And gave me the correct results.

Translate