Forum Discussion

lizrowden's avatar
lizrowden
Icon for Helper I rankHelper I
6 years ago
Solved

evaluate a tables with multiple rows

I would like to create a new column in a table that will evaluate the rows on another details table for each call to determine if the value “Yes” exists. The field that contains the value “Yes” is a ...
Need Help
  • sturlaws's avatar
    sturlaws
    6 years ago

    Hi lizrowden ,

     

    you can create a calculated column like this:

    Column =
IF (
    COUNTROWS (
        FILTER (
            ALL ( warranty );
            warranty[Call # ] = 'call'[Call #]
                && warranty[Is Warranty] = "Yes"
        )
    ) >= 1;
    "Yes";
    "No"
)

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi lizrowden ,

 

you can create a calculated column like this:

Column =
IF (
    COUNTROWS (
        FILTER (
            ALL ( warranty );
            warranty[Call # ] = 'call'[Call #]
                && warranty[Is Warranty] = "Yes"
        )
    ) >= 1;
    "Yes";
    "No"
)

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.