I have a query with Posting period in the columns and a structure with certain KPIs in the rows. Some of these KPIs are daily averages. To make it simple: I have a key figure in one row. In another row I have a formula calculating the number of days based on the Posting period (using a replacementh path variable in the formula). In a third row the key figure is divided by the number of days in the period.
This works perfectly well without any drilldowns. It even works with drilldowns. The problem arises when you filter on only the KPI, or on the KPI and the number of days, and then drilldown on some characteristic. I then get "No applicable data found". However, when also including another row in the filter, with a not-per-day key figure, I do get the correct result.
I believe the problem is the formula for the number of days. Why won't this formula return a result for a drilldown unless another key figure is displayed as well?