Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculation not working

Hi All,   I'm trying to create a calulated column like below and its not working for me. Please advice what should be done in place of this.     Regards, Himanshu
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Finally came up with the below calculation which is somewhat as expected.

     

    Assignee/Watcher =
    SWITCH(TRUE(),
    Ticket_View[Isactive] = 1, "Assignee" & " - " & Ticket_View[Username],
    Ticket_View[Isactive] = 0, "Watcher" & " - " & Ticket_View[Username],
    "NA")
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I've already created individual columns

 

But the issue if when filtering the data , we've a value "NA" so it can be confusing for a user.

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Finally came up with the below calculation which is somewhat as expected.

 

Assignee/Watcher =
SWITCH(TRUE(),
Ticket_View[Isactive] = 1, "Assignee" & " - " & Ticket_View[Username],
Ticket_View[Isactive] = 0, "Watcher" & " - " & Ticket_View[Username],
"NA")