Skip to content

    • Magic ETL

    Magic ETL

    Concat percent sign (%) after a beast mode calculation. Syntax Error

    Member
    in Magic ETL

    Hi, 

     

    I created a BeastMode calculation to create a basic percentage value. However, when I try to enter the formula into a concat it give me syntax error. 

     

    Works:

    count (`Have License`) / count (`Total Users`) * 100

     

    Does Not Work

    Concat ( count (`Have License`) / count (`Total Users`) * 100), `%`)

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Domo Employee
      Answer ✓

      Give this a shot:

      1. CONCAT( count(`Have License`) / count(`Total Users`) * 100, '%')

       

      Might've been the % was enclosed in ` instead of ' 

    Answers

    • Domo Employee

      Looks like you need to add a ( before your formula.

       

      Try this 

      Concat ( (count (`Have License`) / count (`Total Users`) * 100), `%`)

    • Member

      Oh, that was just a typo. Sorry. The formula works, I just cannot get the "%" to concat to that formula 

    • Domo Employee
      Answer ✓

      Give this a shot:

      1. CONCAT( count(`Have License`) / count(`Total Users`) * 100, '%')

       

      Might've been the % was enclosed in ` instead of ' 

    • Member

      You were right! Thank you so much. Worked like a charm. I will have to look up when to use backquote vs regular single quote 

    • Domo Employee

      You'll want to use the tilda (`) anytime you're encapsulating a columnname present in your dataset. You'll use the single quote (') when you are enclosing a string. In your case, you're adding a string '%' to the end of your calculation.

       

      Hope that helps

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories