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(Events) > 1)
 
But it produces an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
 
How can I count rows in a related table only if the related table has more than 1 related record?
 
Thanks!
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
     

2 Replies

  • 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