AshfordMH Contributor

Not sure what was different, but that worked! Thanks so much! 

Yes, thats in the Summary number on the card... also, I added the Max as you mentioned, Invalid Formula : This calculation contained a syntax error

Sure, thanks for your patience! CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px; padding:7px;font-weight:normal">', (CASE When `Collector/Reseller` = 'No' then 'Regular' Else `Collector/Reseller` End),'</div>')

Thanks - it is working, but showing this: (See attached)

Thanks for your help - although i think the MAX function is throwing it off so that it doe not validate..

@mbelmont Still not working for me, could you please advise? : max((CASE CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px; padding:7px;font-weight:normal">' When `XX` = 'No' then 'Regular' Else `XX` '</div>') End))

Has anyone had success using HTML on a Beast Mode that uses a Case statemtent? Could that work? An example: max((CASE When `XX` = 'No' then 'Regular' Else `XX` End'))

@SJ try using an ETL dataflow and excluding the sensitive columns in the final output. That should remove the column that you want in the drill down.

Hey there, Thanks for the tip on the alpha connector. Already got this info from the account manager and DOMO working on getting it up and running in our instance.