SOLine - Margin i % - Acumatica Generic Inquiries & Pivot Tables

RE: SOLine - Margin i %

Fosse — Mon, 22 Nov 2021 06:43:14 +0000

@wyatt-erp Thanks! I owe you one!

Wyatt.ERP — Fri, 19 Nov 2021 18:27:33 +0000

You'll need to check for 0s when you do division. Also, you'll probably want to use instead of .

=IIF(=0,0,Round(((-)/)*100,0))

Fosse — Fri, 19 Nov 2021 13:34:24 +0000

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((-)/()*100,0)

Does anyone has any ideas?

/Jonas

2616 2617