Calculation error in beast mode

user02117
user02117 Member
in Archive

I get an error when I try to validate this:

 

CONCAT(
  '$',
  SUBSTRING(ROUND(SUM(`Transactions`)/1000000,0),1,3),
  'U',
  '<br /><font size=-1>',
  SUBSTRING(ROUND(100*(SUM(`Transactions`)/10000000),0),1,3),
  '% Summary Title </font>'
  )
 
Even though this same code works on on a different data source. The transactions variable is numeric.
 
Thanks

Comments

  • cwolman
    cwolman Contributor

    The beast mode validates fine when I tried it by replacing the `Transactions` column with a numeric column from my dataset.  Are you sure `Transactions` is the correct column?


    -----------------
    Chris
  • user02117
    user02117 Member

    Yes, it's listed under Measures when I edit a card and it can successfully SUM in cards as well

  • ST_Superman
    ST_Superman Domo Employee

    Is `Transactions` another beast mode calculation?

Categories