Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
5 years ago
Solved

Count Rows , Related Table > 1

Hello,   I am trying to count rows of a related table , but only if the related table has more than 1 record. Here is my formula,   Launched Accounts = CALCULATE(COUNTROWS('Cases'),RELATEDTABLE(...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey lcasey ,

     

    you can just return BLANK if the number is 1 or smaller. Try the following calculated column:

    Launched Accounts =
VAR vRowsRelated =
    CALCULATE(
        COUNTROWS(
            RELATEDTABLE( Cases )
        )
    )
RETURN
    IF(
        vRowsRelated > 1,
        vRowsRelated,
        BLANK()
    )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey lcasey ,

 

you can just return BLANK if the number is 1 or smaller. Try the following calculated column:

Launched Accounts =
VAR vRowsRelated =
    CALCULATE(
        COUNTROWS(
            RELATEDTABLE( Cases )
        )
    )
RETURN
    IF(
        vRowsRelated > 1,
        vRowsRelated,
        BLANK()
    )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
lcasey's avatar
lcasey
Post Prodigy
5 years ago

Thank You!