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")

5 Replies

  • AilleryO's avatar
    AilleryO
    Memorable Member
    4 years ago

    Hi,

     

    You can try :

    =TRUE()   and   =FALSE()    instead of 1 and 0

    Or as the yellow banner says use VALUE(YourColumn) instead of YourColumn directly.

     

    and maybe remove UserName ?

    or are you trying to concanate the results ?

    In this case it shoud be :

    UserName & "Watcher"    or  UserName & "Assignee"    as a result in your formula.

     

    Can you tell us more ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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)

       

      • AilleryO's avatar
        AilleryO
        Memorable Member
        4 years ago

        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 ?