AnsweredAssumed Answered

Calculate raito

Question asked by CCweedcontrol on Sep 21, 2020
Latest reply on Sep 21, 2020 by CCweedcontrol

I need to calculate ratio between two numbers than to percent but some rows in both field1 and field2 have zero values.

Simple calculator field2 / field1 * 100 but field1 has zeros, how do I by pass the rows with zeros in field1 in field calculator?

 

Field 1   field 2

0            15200 --> can't divide 0/15200

Outcomes