Link to home
Start Free TrialLog in
Avatar of Jeff S
Jeff SFlag for United States of America

asked on

Percent Formula

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
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jeff S

ASKER

Thank you