Label/Expression syntax

[#1]

This is giving me fits, I have a Field, Response_Time, that is bucketed into different SLA time brackets (Live, Electronic and Other) from a call center application. I have an IF Expression statement working to select/count the call data according to the dynamic GetFieldSelection(xxxxxx)  but can't get the Expression Label to work dynamically for the heading.

=if(GetfieldSelections(Call_Source)='Live','< 1 minute') works But extending it with another If like the Data selects doesn't.

=if(GetFieldSelections(Call_Source)='Live','< 1 minute'), if(GetFieldSelections(Call_Source)='Electronic','< 5 minutes'), if(GetFieldSelections(Call_Source)='Other','< 7 minutes'),

Thanks

David Rowe

[rwunderlich]

Is only one Call_Source always selected?

-Rob

[#3]

Yes, only one source.

[rwunderlich · Accepted solution]

Leave off the GetFieldSelections() and just try:

=if(Call_Source='Live','< 1 minute'

, if(Call_Source='Electronic','< 5 minutes'

, if(Call_Source='Other','< 7 minutes'

, '????'

)))

-Rob

http://robwunderlich.com

[#5]

Thanks Rob. Good pointer, made sense as a single source.

DR