Percent Formula

Jeff S
Jeff S used Ask the Experts™
on
I am needing help creating a Percentage Formula. When I ran my original formula, I got back a division by zero error. My hunch tells me I need to account for values in zero with IF and ELSE somehow. Basically I need to know the collection ratio and account for zero payments. Any assistance is appreciated.

{data.ChargeAmount}/{data.PaymentAmount} * 100
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try this

If {data.PaymentAmount} = 0 then
     0
Else
    {data.ChargeAmount} / {data.PaymentAmount} * 100

mlmcc

Author

Commented:
Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial