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!

danielrabinovit

Posted 1 year ago·Last reply 1 year ago

4 comments

danielrabinovit

OP1 year ago

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])

DRay

·1 year ago

Hi danielrabinovit,

I'm happy to hear you were able to solve it!

Can you share your solution so if anyone has the same question they can find the answer?

Thank you.

danielrabinovit

OP1 year ago

Problem has been solved.

DRay

·1 year ago

Hi danielrabinovit.

That's great to hear. How did you end up solving it?