Forum Discussion
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
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")
OK so you should remove from your formula the "Watcher" and "Assignee".
It should be :
SWITCH (TRUE(),
IsActive = 1, "Assignee" & UserName,
IsActive = 0, "Watcher" & UserName,
"Not Existing")
Or it could be done in 2 different columns depends on your needs ?
Tell us if it works ?
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.
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")