8 Replies Latest reply: Apr 16, 2017 2:57 PM by Erick Dameron RSS

    Help with Chart expression!

    Erick Dameron

      HI Experts!

       

      I am having a couple issues.

       

      The first is the Sum of my daily target and then multiply by the number of working days within date range.

       

      I get a number using:

       

      Sum(DailyPT)*Networkdays(Min(date),Max(date)))

       

      However what I really need to use is:

       

      SUm(DailyPT)*Networkdays(Monthstart(date),Monthend(date)))

       

      because it should include all work days in each month and if we are only halfway through a month, still count the days to come.

       

      This expression doesn't work, i get a null value.

       

      DailyPT is a dollar target like $395.

      Monthly should be: 395 * (# of m-f days in month)

      Yearly should be: 395 * (# of work days in a year)

       

       

       

       

      Any thoughts?