Solved
Formula Help
Hi Everyone,
I need to create a formula for an indicator widget which will count all rows in a certain column that meets a condition divided by all rows in that column.
For clarity, I want to count all Hardware Types where the power condition is on, divided by count of all hardware types.
I am sure this is a really easy formula to put in, but I just cant seem to get it to work.
Thanks!
Hi DRay,
It was actually a much simpler solution than i thought. I just added a custom column that put a 1 or a 0 in depedning if the condition I was looking for was met using. And then summing that divided by the total number of rows.
CASE WHEN [{condition}] = '{condition met}' THEN 1 ELSE 0 END
and then
(sum([Column_name])/[# of rows])
