AnsweredAssumed Answered

SUM range of fields and find largest

Question asked by jacobrodel on Mar 1, 2016
Latest reply on Mar 1, 2016 by bixb0012

I have a point feature class with fields representing hourly precipitation amounts for a particular storm and many thousands of records.  The number of fields will vary from storm to storm.  I am trying to get the max 6 hour precipitation amounts.  I need it to list fields, SUM row for 1st-6th field, and assign it to Max Precip Field.  Then SUM row for fields 2-7 and if it is larger than 1-6 assign that value, if not leave it the 1-6 value.  Need this to loop till the end of the fields and for every record.  Can somebody recommend the best way and some syntax to accomplish this?  Would this be best accomplished with a numpy array or Update cursor? 

Outcomes