Calculation error in beast mode

Reply
Visitor

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
Green Belt

Re: Calculation error in beast mode

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?

Highlighted
Visitor

Re: Calculation error in beast mode

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

Red Belt

Re: Calculation error in beast mode

Is `Transactions` another beast mode calculation?


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Announcements
Call for Presenters! We want to hear your Domo story, submit your entry and win a free pass to Domopalooza 2019!. Click here!