Calculation error in beast mode

user02117

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

cwolman

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?