Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have a problem with a chart that i have join for you!
The dimension are the month and the number of late week and my expression is:
=RangeSum((count(id_commessa) / count (total <Mois_année> id_commessa)), above([pourcentage_cumul]))
The expression is alright but when i didn't have data as september 2012 for 2 and 4 weeks late i want the valor equal to 100%
Have you got an idea to resolve that?
Thank you very much have a good day
maybe this:
=RangeSum( if(isnull(id_commessa),1,(count(id_commessa) / count (total <Mois_année> id_commessa))), above([pourcentage_cumul]))
hi gwassenaar,
it doesn't work and i try
=RangeSum( if(isnull(count(id_commessa)),1,(count(id_commessa)/ count (total <Mois_année> id_commessa) )), above([pourcentage_cumul]))
and it doesn't work to!
i don't know if we resolve this problem a day!!!
Thanks gwassenaar