This content has been marked as final. Show 2 replies
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?