5 Replies Latest reply on Jul 24, 2018 5:50 PM by Zhouyi Zhang

    Calculating running sum along with Linearity

    Shelnes Elie

      Hello community,


      This is my first time posting on this site. So here's my situation:


      So I'm trying to do a calculation for the linearity in percentage. The formula is:


      Running Sum Sales / (Target Number)


      The target number is a manual number and different for each quarter. I'm trying to do a calculation that will do the running sum throughout the year, restart at the beginning of a new quarter and incorporate the new target number. Here's what I have so far. I'm using 1000 Start Ups as the data set with the Order Date and sales fields. I'm only using one year. Please help with the calculation or a better method: