Forum Discussion
Calculation not working
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")
Have already tried true/False its not working .
I'm trying to create a column where when the below condition meet it gives me "Assignee" and "Watcher"
Condition1 : isactive = 1 and then it should give me the username ( Which will be Assignee name)
Condition 2 : isactive = 0 and then also it should give username( which will be watcher)
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")