Skip to main content
Solved

Calculation in Generic Inquiry using Attributes issue with Data field

L
Varsity I
Forum|alt.badge.img

Hi @Naveen B , All,

 

I have the following Generic Inquiry which I need to calculate a new cost from the attributes against the Item.  I think the calculation is not working due to the data types but am struggling with what prefix to use.

Attributes:-

I have tried using the Mask without luck also.  The generic inquiry is attached.

Any help appreciated.

Regards,

laura

 

Best answer by Naveen Boga

 Hi @lauracastagna    Since the Mass attribute value is less than 0.5 i.e., 0..3, it is considered 0 and getting the result as 0.

Please use the below formula and it will work with the 0.

Please use the CDbl instead of CDec conversion.

=CDbl((IsNull([Length.Value],0)))*CDbl((IsNull([Rate.Value],0)))*CDbl((IsNull([Mass.Value],0)))+ CDbl( (IsNull([Punch.Value],0)))

 

 Hi @lauracastagna  Since the Mass attribute value is less than 0.5 i.e., 0..3, it is considered 0 and getting result as 0.

Please use the below formula and it will work with the 0.

Please use the CDbl instead of CDec conversion.

=CDbl((IsNull([Length.Value],0)))*CDbl((IsNull([Rate.Value],0)))*CDbl((IsNull([Mass.Value],0)))+ CDbl( (IsNull([Punch.Value],0)))

 

 

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

13 replies

V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • 871 replies
  • February 1, 2022

Hi @lauracastagna 

Could not open the GI, got following error. 

 

Just send the screenshot reflecting the expression you have used for specific column in question. 

Regards,

VijayKumarU
jinin
Pro I
Forum|alt.badge.img+11
  • jinin
  • Pro I
  • 699 replies
  • February 1, 2022

Hi @lauracastagna 

Please use the value field instead of attributeID

you wrote like below

=CDec(([Length.AttributeID])*CDec([Rate.AttributeID])*CDec([Mass.AttributeID]))

It should be 

=CDec(([Length.Value])*CDec([Rate.Value])*CDec([Mass.Value]))

I tried and was able to get the calculated value. 

We should use Entry Mask as well,

 

 

Jini N
L
Varsity I
Forum|alt.badge.img
  • lauracastagna
  • Author
  • Varsity I
  • 66 replies
  • February 1, 2022

Hi,

still no luck when i changed it.  including the mask on the Attribute:-

 

jinin
Pro I
Forum|alt.badge.img+11
  • jinin
  • Pro I
  • 699 replies
  • February 1, 2022

Hi @lauracastagna 

In your GI the Condition was added wrongly. I’ve corrected and verified. Please find the sample xml for your verification.

1 Attachments
Jini N
L
Chris Hackett
2 people like this
  • L
    lauracastagna
  • Chris Hackett
    Chris Hackett
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3404 replies
  • February 1, 2022

Hi, @lauracastagna Hope you are doing well!

The above solution provided by @jinin is working as expected! Do you see still error?

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
L
Varsity I
Forum|alt.badge.img
  • lauracastagna
  • Author
  • Varsity I
  • 66 replies
  • February 2, 2022

Thank-you @jinin and  @Naveen B

“some” don’t calculate still.  I cant work out the difference. 

Also I had to add “+” Attribute Punch.

Could you please take a look?

 

1 Attachments
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3404 replies
  • February 2, 2022

Hi, @lauracastagna  I see some issue with JOIN conditions and due to that you are not able to fetch the expected value. I have attached the working GI here, please verify.

Here are the issue and fix details

Join condition should be like → Punch.AttributeID Equals =’Punch’, and I have seen the same issue with the Glass related attributes and I have modified it. Please find the latest attached XML GI for your reference. 

 

 

 

 

1 Attachments
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
S
1 person likes this
  • S
    Shurtugal98
L
Varsity I
Forum|alt.badge.img
  • lauracastagna
  • Author
  • Varsity I
  • 66 replies
  • February 2, 2022

thanks @Naveen B .

hopefully the last thing……

when there is No punch value the calculation does not work.  I’m not multiplying just adding so not sure what I’ve missed.

 

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3404 replies
  • February 2, 2022

Hi @lauracastagna  I have removed the grouping and added NULL conditions to the formula.

Please find the attached updated GI.

 

1 Attachments
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
L
Varsity I
Forum|alt.badge.img
  • lauracastagna
  • Author
  • Varsity I
  • 66 replies
  • February 2, 2022

Hya,  still some that wont populate @Naveen B 

 

 

1 Attachments
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3404 replies
  • Answer
  • February 2, 2022

 Hi @lauracastagna    Since the Mass attribute value is less than 0.5 i.e., 0..3, it is considered 0 and getting the result as 0.

Please use the below formula and it will work with the 0.

Please use the CDbl instead of CDec conversion.

=CDbl((IsNull([Length.Value],0)))*CDbl((IsNull([Rate.Value],0)))*CDbl((IsNull([Mass.Value],0)))+ CDbl( (IsNull([Punch.Value],0)))

 

 Hi @lauracastagna  Since the Mass attribute value is less than 0.5 i.e., 0..3, it is considered 0 and getting result as 0.

Please use the below formula and it will work with the 0.

Please use the CDbl instead of CDec conversion.

=CDbl((IsNull([Length.Value],0)))*CDbl((IsNull([Rate.Value],0)))*CDbl((IsNull([Mass.Value],0)))+ CDbl( (IsNull([Punch.Value],0)))

 

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
L
Varsity I
Forum|alt.badge.img
  • lauracastagna
  • Author
  • Varsity I
  • 66 replies
  • February 2, 2022

THANK YOU @Naveen B !

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3404 replies
  • February 2, 2022

Most Welcome @lauracastagna 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved