2 Replies Latest reply on Oct 2, 2018 10:41 AM by maneesh.gaddam

    Help with a calculation! (using value for a particular month for prior month)

    Vikash Karra

       

      Hey guys - unfortunately I am unable to attach the workbook. TO keep this simple, we have two months as you can see. We have 8 days in August, and 7 in September. That 4315 value in August is determined by taking (6904/8) * 5. What needs to happen, is if the days in current month is less than the days in the prior month, they want to use the days in the current month as the denominator (so basically, it would be (6904/7) * 5 = 4391. We are struggling with this one!! Any help would be appreciated