0 Replies Latest reply on Oct 23, 2018 9:26 AM by Troy Brommenschenkel

    Apply a calculated field result to Null data

    Troy Brommenschenkel

      Hello All,

       

      I'm hoping that this is even possible.  What I am attempting to do is take the results of a calculated field within a specific date range and carry those values over and/or apply them to older fields that have null values. The data looks like this currently:

      The values in the bottom row (1.18%, 1.17%, ect.), I would like to take these values from September 2017 to August 2018 and insert them into the Null fields going backward to 2015.  Or if anyone knows an easier way to do this not in Excel (there are 4M rows of data), I am all ears? 

       

      Thanks in advance!