3 Replies Latest reply on Nov 30, 2016 2:43 AM by Mahfooj Khan

    nb days in an expression

    wiem bekir

      Hello Guys,

      I need to measure the number of days of a month dynamically and then put this measure into an expression :

      So I did like that : nb days = DATEPART('day',dateadd('day',-1,DATETRUNC('month', DATEADD('month',1,[OPEN_TIME]))))

       

      my expression is :

       

      1-(sum([Sector hours of unavailability Planned]))

      /((30*24*60*13292) - (sum([Sector hours of unavailability Unplanned]))) *100

      END

       

      I should replace 30 in my expression by the nb days but I get this error :

       

      Capture.PNG