Number of days with records

[#1]

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

[MK_QSL]

=COUNT({<kpi3 = {"=not IsNull(kpi3)"}>}DISTINCT Date)

[#3]

This is not correct. I am also looking for a solution using variables.