Spreadsheet-style format code to show both numbers in Millions and Percentages

  • 10 October 2022
  • 0 replies

In the chart above, I am trying to visualise absolute numbers in Millions and MoM% change in percentages. 

In the data table there are negative MoM changes, which however are not shown with a negative sign in the visualisation. 

The spreadsheet style formatting code I am using is the following:


I can’t get past this last little issue with negative percentages. 

Would be glad to anyone who could step in and help out!

This topic has been closed for comments