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:




      However what I really need to use is:




      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?