Mathematical Calculation

[nigharikkha]

Hi 

I have a table with fields as shown below (sample data).

I need to calculate the failure rate and display in the text box.

Failure Rate = (Number of distinct Label with Fail=1) / Number of distinct Label

In this example, Number of distinct Label with Fail=1 is 1 and Number of distinct Label is 2.

Please help with the expression for this.

[nigharikkha · Accepted solution]

I completed this using the below expression in the text box.

=Count(distinct{<Fail = {1}>}Label) & ' / ' &Count(distinct Label)