Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table that shows the amount of inspections done per room and I need to calculate the percentage done based on it if passed or not.
So for the "Dated" inspections there was 3 in total and only 2 passed, so it's 2/3 = 67% which I wrote out the expression like this:
Count({<Dated={'Yes'}>}Dated)/Count([Unit])
*Count the total Dated inspections that = yes and / it by the count of units
I'm getting 100% but I know it should be 67%. Any ideas?
Thanks!!
Thank you Devarasu, that helped and it's working!
Now my only thing is that I'm showing too much information in my table. I'm showing the amount passed to be able to show the percentage. What I did was this: Count({<Dated={'Yes'}>}Dated)/Count(Unit) for the Dated % which is perfect but I'd rather not have to have the Dated Passed column. Is there a way to do that or am I just doing all of this wrong .