10 Replies Latest reply on May 10, 2018 7:29 AM by Shinichiro Murakami

    Calculating remaining days in the quarter, then divide a figure by the remaining days

    Darren Lieu

      Good morning,

       

      I am running into an issue of using the remaining days in the quarter calculated field.

       

      I was able to successfully create a calculated field to determine the remaining days in the quarter. However when I try to divide a figure, which in this case is our quarterly plan minus QTD revenue, by the remaining days in the quarter, I do not get an exact number. I am trying to determine our re-forecasted plan figure for the remaining days in the quarter in order to reach our quarterly plan.

       

      Thanks,