Need Help on average

[Pinky]

Hi,

My data is like below. I need to calculate the average like below

1. All True/Total numbers.. I am expecting answer for this 2/4 =0.5

2. All true/Total Critical numbers etc....Answer should be like 1/1 .Can anyone help on this? Thanks!

Number	Status	Concdition
A	Critical	TRUE
A	Critical	TRUE
A	Critical	TRUE
B	High	FALSE
B	High	FALSE
B	High	FALSE
C	Medium	TRUE
C	Medium	TRUE
C	Medium	TRUE
D	Low	FALSE
D	Low	FALSE
D	Low	FALSE

[Pinky]

I am unable to open the workflow. I have tried open and edit with Notepad++ and changed version and still unable to open it.

Can you help me on this?

[Pinky]

I am able to open the workflow.Thanks! please ignore my previous reply!

[ponraj]

Does it solve your problem?

[Pinky]

Thank you for great support!

I got the Total average but unable to get each status average.

I have huge data there 4 status which is 1. Critical 2.High 3.Medium 4. Low

I need to calculate each status average like this. Total True's/Total no.of critical numbers

For high -- Total True/Total no.of High numbers.

Can you help on this?

[Pinky]

I got the solution. Instead of Count distinct i used Count. Thanks for your great support.