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]

      END

       

      i have attached the sheet here

       

      how can i do this?