2 Replies Latest reply: Sep 19, 2014 6:01 AM by Ivelin Iliev RSS

    Number of days with records

      Hi everyone,


      I am working on a simple forecast based on the MTD amount and number of days in the month. For example, if the revenue for

      Aug 1-10 is 300eur, the full month forecast will be: 300eur / 10days * 30days


      So far I've been using Num(Max(Date) - Monthstart(Max(Date))) +1 to get the number of days until Today. However, there might be days with missing data for some KPIs which I want to exclude. If you take a look at the attached .qvw, kpi3 has only 6 days with records and therefore the calculation should be divided by 6 instead of 17. Any ideas how to solve this?