By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
1
Posts
1
Users
1
Reactions
1,966
Views
March 14, 2022 8:50 am
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?
