14 Replies Latest reply on Jun 17, 2014 1:18 PM by EMPCREATE

    how to "carry over" and calculate YTD fields for 12 months

    EMPCREATE

      Need to calculate fields then carry them over to next month and total them. Example:  JAN: "food"= $100  YTD =$100  FEB: "food"=$100 therefore YTD2 would be $200. But I have 7 fields that need to be added for YTD2-Total Net Sales as well...And I need to do this for all 12 months of the year.

       

      Your help would be much appreciated...

       

      Thanks,

      Mike