Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks,
Ivelin
=COUNT({<kpi3 = {"=not IsNull(kpi3)"}>}DISTINCT Date)
This is not correct. I am also looking for a solution using variables.