Exporting PPT issues

Joshua_Reyes

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,

Domo_Diesel

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

jasmin_guevarra

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