Only use dimension with value

[pauldamen]

Hi,

I have a graph were I divide the number of hours with the number of people (in printscreen see top line chart)

What you see in my listbox on the left I have 8 people. But only 4 with hours (see bottom table). Now it divides the number of hours with 8 people. What I need is that the number of hours is divided by only people who have hours. How can I achieve this?

Regards, Paul

[sunny_talwar · Accepted solution]

You have not shared your expression, but based on some assumptions, try this:

=Sum({<TypeUrenHoofdcategorie = {'Productief'}>} Uren)/Count(DISTINCT {<Finexter = {"=Sum({<TypeUrenHoofdcategorie = {'Productief'}>} Uren) > 0"}>} Finexter)

[pauldamen]

Thanks Sunny, works great!