Skip to content

    • Charting

    Charting

    Calculated field doesn't respect parentheses in arithmetic expressions?

    Member
    in Charting

    Hello - I'm new to Domo but observing very unusual behaviour on a calculated field.

    When I define the expression

    10*(2-1)

    It evaluates to 19 (i.e. 10*2 - 1), not 10 as expected!

    Bizarrely my colleague on the same instance is unable to reproduce the same.

    As a workaround, I've been wrapping bracketed expressions in a POWER function i.e.

    10*POWER(2-1,1)

    evaluates to 10 as expected.

    Has anyone experienced this before? If so, how can I resolve?

    Thanks in advance

    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

    Answers

    • Coach

      @DavidLee

      Can you post your exact formula you're using? Also are you doing this in a beast mode or in a magic ETL formula tile?

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thanks both, for some reason I can't attach a screenshot to prove it, but the calculated formula I'm using to test is literally

      10*(2-1)

      Which evaluates to 19 while 10*POWER(2-1,1) evaluates to 10 as expected.

      This is for a DataSet view which I created in Analyser. I'm adding the above as a Calculated Column in the data tab (not a Beast Mode calculation in the visualiser as it looks like @amehdad assumes)

    • Coach

      I was able to recreate your problem now that you describe that you are doing it when using the dataset view option in Analyzer. That view in Analyzer is new, and I believe you found a bug. I would submit a ticket to support@domo.com and explain your bug. They will send it to the engineers to get it fixed.

      In the meantime, I would try and work around it by using a beast mode.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    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