Calculation error in beast mode

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

  • 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?

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

  • Is `Transactions` another beast mode calculation?