4 Replies Latest reply on Sep 1, 2018 9:48 AM by Deepak Rai

    Help with calculation field

    Imran Azam

      Hi guys


      I am trying to create a calculation field which will do the following


      If MONTH is more or equal to  start date field  AND MONTH is LESS or equal to End date  field Then total/lenth

      else leave it blank


      i did the below but it doesnt work


      IF [Month] <= [End] and [Month Year] => [Start]

      THEN [total]/[lenth]



      i have attached the sheet here


      how can i do this?