By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
November 19, 2021 8:34 am
Hi,
I am making a Generic Inquiry were I want to show the Margin i %.
When I try to ad this code and runs the Generic Inquiry I get Divide by zero error encountered error.
=Round(([SOLine.CuryLineAmt]-[SOLine.CuryUnitCost])/([SOLine.CuryLineAmt])*100,0)
Does anyone has any ideas?
/Jonas
2 Replies
November 19, 2021 1:27 pm
You'll need to check for 0s when you do division. Also, you'll probably want to use [SOLine.CuryExtCost] instead of [SOLine.CuryLineCost].
=IIF([SOLine.CuryLineAmt]=0,0,Round((([SOLine.CuryLineAmt]-[SOLine.CuryExtCost])/[SOLine.CuryLineAmt])*100,0))
November 22, 2021 1:43 am