I have the following function

[FelipeMendes]

I have the following function =IF(LEFT(OBS_MOTIVO,3)='L01','L01', IF(LEFT(OBS_MOTIVO,3)='L02','L02',IF(LEFT(OBS_MOTIVO,3)='L03 ','L03'))) which is used to measure the number of calls that an operator makes, but it only counts the result for those who close the NRS. And it ends up harming whoever made the call but did not close the NRS, so we had the idea of ​​generating a code for the operator, but we need this code to appear together in the column where it informs if the connection was L01 L02 or L03.

Example

C22-L01 OR C22 L01

[vinieme12]

try this instead

if(SubStringCount ( 'OBS_MOTIVO','L01'),'L01'

,if(SubStringCount ( 'OBS_MOTIVO','L02'),'L02'

,if(SubStringCount ( 'OBS_MOTIVO','L03'),'L03')))