Calculated field doesn't respect parentheses in arithmetic expressions?

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

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    @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!**
  • 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)

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    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 [email protected] 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.

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