4 Replies Latest reply: May 15, 2017 11:30 AM by beck bakytbek RSS

    Difference in Month

    beck bakytbek

      Hi Folks,

       

      i have a situation and it does look like (see attached screenshot)

       

      for instance:

       

      ID      FromDate           ToDate      Amount      Difference (days)       Amount / Difference

      4       20.03.2017      31.07.2017         272               133                         2,05

       

      my question are:

       

      1, how to bild from: Difference (day) = Difference (month) : for examlpe > 133 days = 4 months, and Amount / Difference  from

      2,05 into 68.

       

      2. how can i bild or implement from Difference (month) in Master Calendar,

       

      my issue is: if i select instead of 31.07.2017 the date 31.06.2017 i have to show 3 months, and my amount is equal to 90,67


      i want to buil the filter like: Jan,Feb,Mrz,Apr and if i select the Months, i want to show the change of my anount.

       

       

      Thanks a lot in advance for your help and suggestions

      Beck