Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Number | Status | Center |
555-555-1711 | In Use | 879090 |
555-555-1711 | Closed | 909840 |
555-555-1711 | Pending | 90876544 |
555-555-1712 | In Use | 3788909 |
Thanks,
May be like this
Dimension
Number
Expression
If(Count(Number) > 1, Only({<Status = {'In Use'}>} Center), Only(Center))
May be like this
Dimension
Number
Expression
If(Count(Number) > 1, Only({<Status = {'In Use'}>} Center), Only(Center))
Hi,
With the phone number as the dimension, you could use
Concat(Distinct {<Status={"In Use"}>} Center)
Hi Sunny,
I tweaked it just a bit to fit my actual column names it it worked perfectly!!
if(count(DISTINCT [Cost Center])>1, Only({<Status = {'In Use'}>} [Cost Center]), Only([Cost Center]))
Thanks so much