Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks Sunny, works great!