How to exclude '-' data

[#1]

I need to create two categories "In client services" which = Jira ticked number being blank/empty/null and

Escalated to PD which = a value in the record

Using the following expression:

if(jira_ticket_number='' or 0 or Null() or '-','In client services','Escalated to PD')

I am still getting '-' values in my dataset, any tips on how to include this in my grouping?

Thank you!

[#2]

I just checked using this formula If(IsNull(jira_ticket_number), 'T', 'F')

and the values test as F for being Null, what else would cause a '-' type record entry?

[sunny_talwar · Accepted solution]

Try like this

If(Len(Trim(jira_ticket_number)) = 0, 'T', 'F')

[#4]

Hi Sunny,

This worked, thank you!

[#5]

actually, I am still getting '-' values

[sunny_talwar]

Can you share the exact script you are using or expression? I am confused where you are using this

[d_prashanthredd]

Hi Monica,

I think you are using other dimensions which are having proper values against this.

[#8]

Hi Sunny, I solved this, there was an issue with my original if expression.

if(jira_ticket_number='' or 0 or Null() or '-','In client services','Escalated to PD')

vs

if(jira_ticket_number=''or jira_ticket_number =0 or isNull(jira_ticket_number) or jira_ticket_number='-' ,'In client services','Escalated to PD')

Thank you