32 Replies Latest reply: Sep 12, 2017 7:34 AM by Sunny Talwar RSS

    If-Sum then Count Distinct

    Kevin Somosera

      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!