Percentage Calculation

Discussion created by Youngy on Oct 2, 2013
Latest reply on Oct 2, 2013 by Youngy
I have tried so many ways to get this working..
I have a line feature class which has two attributes. There is a field called sum_length and one attribute has 120m and one has 7m. These two summed values change when other tasks are run. I have been asked if it is possible to calculate if the lower value is higher than 20% of the higher value. I have another text field for the output which would read higher/lower than 20% depending on the result.

I have tried to export these two attributes to stand alone tables and join so I have both figures in the one row then I thought I could run the field calculator but no joy.

Any help would be very much appreciated