Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Pavol Procka
    Formatting based on two columnsAnswered
    Topic posted March 28, 2018 by Pavol ProckaSilver Crown: 22,500+ Points 
    46 Views, 1 Comment
    Title:
    Formatting based on two columns
    Content:

    Hi,

    any advisce how I should go about combining values from two columns?

    Basically, I have one column based on a custom field called member value which outputs either Norm (normal customer) and HV (high value customer) like: if((incidents.c$membervaluepriority >= 80),'HV','Norm')

    Then I have a column that outputs the group the incident is assigned to (accounts.group_id).

    What I would like to achieve is a column that combines these two in the following way: output 1st column, but if the group equals selected groups (3 out of many) change the output from Norm of HV to VIP.

     

    Many thanks

    Pavol

     

    Best Comment

    Pavol Procka

    ok, looks like I got the correct answer: IF(accounts.group_id IN(103180,102789,184623),'vip',if((incidents.c$membervaluepriority >= 80),'HV','Norm'))

     

    Comment

     

    • Pavol Procka

      ok, looks like I got the correct answer: IF(accounts.group_id IN(103180,102789,184623),'vip',if((incidents.c$membervaluepriority >= 80),'HV','Norm'))