Questions Percentage Calculation not outputting the correct percentages.

Acumatica Generic Inquiries & Pivot Tables

Last Post by Glenn Allin 4 years ago

1 Posts

1 Users

1 Reactions

2,103 Views

RSS

Posts: 4

Glenn Allin

Topic starter

March 14, 2022 8:50 am

(@gallin)

Active Member

Joined: 4 years ago

Hi all, I am trying to calculate profit as a %. I have managed to find (i think) a good formula to work, by avoiding the divide by zero error...however it's not returning the correct profit percentages. The attached shows

=Concat (CStr (CInt (IIf ( [FSAppointmentDet.Qty] = 0, 0 , ([FSAppointmentDet.ExtCost] - [FSAppointmentDet.Qty] ) / [FSAppointmentDet.Qty] * 1))) ,' %')

However the percentages are off. Can anyone help?

12 Forums
2,533 Topics
11 K Posts
72 Online
2,439 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)