AnsweredAssumed Answered

Counting instances of non-zero fields in a record

Question asked by DAFoxFL on Jul 29, 2016
Latest reply on Aug 24, 2016 by DAFoxFL


Referring to the table snippet above, each record has five fields for the last five fiscal years. The data will be either the number of that year or zero.


I need to calculate the Burns_5Yrs field based on the count of the number of non-zero years (in fields FY11 - FY15) in that record. The first three rows have examples manually entered. For example, the first record has activity in FY11 and FY14 so the result for Burns_5Yrs should be 2. The second row is also 2 and the third row is 4.


I've been doing this manually but now I have a table with 198 records so I'd like a programming solution, preferably in Python. Any help would be appreciated as I really don't know where to start.