3 Replies Latest reply: Mar 30, 2017 4:28 AM by Juliette Johnson RSS

    Displaying a value based on another value in a table

    Juliette Johnson

      I have a table that looks something like this.   In some cases there are multiple cost centers for one phone number.  In these cases, I would like to write an expression that will only show the cost center associated with the status "in Use". In my example below, that would be cost center 879090

      Is this possible?

       

       

      NumberStatusCenter
      555-555-1711In Use879090
      555-555-1711Closed909840
      555-555-1711Pending90876544
      555-555-1712In Use3788909

       

      Thanks,