Exporting PPT issues

Joshua_Reyes
Joshua_Reyes Member
in Archive

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,

Comments

  • Domo_Diesel
    Domo_Diesel Domo Employee

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

  • jasmin_guevarra
    jasmin_guevarra Member

    @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,

This discussion has been closed.

Categories