Exporting PPT issues

Hello All,

 

Unsure if this has been mentioned, but we have used the PPT exporting options to review our data on both monthly and weekly levels, but have come across what appears to be a coding error where the summary field adds 
'<span style="color:green">' with the respective data fields. 

 

Thank you,

Joshua Reyes
------------------------
Marketing Analyst | TeletracNavman

Comments

  • @Joshua_Reyes Happy to help with this.  Are you using html in beast mode for the summary number?

  • @Domo_Diesel @Joshua_Reyes 

    Yes, we are currently using HTML in the beast mode calculations. Please see example:

     

    CONCAT(
    'Plan:',

    ROUND(CONCAT(SUM(CASE WHEN `Scenario`='Plan' THEN `Numerator` ELSE 0 END),''))*1,

    ' | ',

    '<span style="color:red">',

    'Actual:',

    ROUND(CONCAT(SUM(CASE WHEN `Scenario`='Act' THEN `Numerator` ELSE 0 END),''))*1,

    '</span>')

     

    Thank you,

    Jasmin Guevarra
    Marketing Analyst | TeletracNavman
This discussion has been closed.