If-Sum then Count Distinct

[ksomosera10]

Hi!

Can you help me out on my problem?

I have this table and text box. Here's what I need. I want to show in my text box the distinct count of people having a specified criteria and condition.

Just to give you an idea, here's a sample data on my table:

|      Name    |  Power        |  Element |    HP    |

|    Batman  |  Batpower  |      Dark  | 1000    |

| Spiderman |    Web        |  Nature  |  900    |

| Aquaman  |Trident Strike|    Water  |  2000  |

On my text box I want to show this kind of expression:

If Element == 'Nature' and HP <= 1000 Then Count Distinct Name

I hope this helps you understand my problems...

Thanks!

[sunny_talwar]

But if Resource Name have more than one Programming, then the combined Sum(nAlloc) could still be greater than 99 for instance....

Resource Name     Programming     nAlloc

ABC                         P1                         80

ABC                         P2                         20

Would you include it or exclude it? I guess depends on the user requirement and data. But our expressions are def. not the same

[Kushal_Chawda]

Bas bhai..tune bol diya to baat khatam.. expression alag he

[sunny_talwar]

Thank you yaar