1 Reply Latest reply on Dec 2, 2019 4:42 PM by shuhei saito

    How to Calculate Completed Months Calculated field using Date

    Saikrishna Kommineni

      I need to create a Calculated Field for Average projects Completed per Month. Using  Projects Complete Measure and No of Completed months for the Calendar year.

       

      Calculated field: Projects Complete / No of Completed Months in the year   Ex : 12 Months per year ( Completed Months: 11)  ( 112/ 11 )  =  10.18

       

      please find the attached workbook Version 2019.2