Hiding markdown in row totals

roberts.cacus · March 25, 2021, 11:24am

The recommended approach is to add a CASE WHEN construct that checks if the current row dimension member is not the total. If you have the Time dimension on rows, the calculation could look similar to the one below:

CASE WHEN [Time].CurrentHierarchyMember.Name <> '$total_aggregate'
THEN
  CASE WHEN [Measures].[Created vs Resolved issues] < 0 THEN
      "<i class='far fa-arrow-up' style='color:green'></i>"
  WHEN [Measures].[Created vs Resolved issues] > 0 THEN
      "<i class='far fa-arrow-down' style='color:red'></i>"
  END
END

The report then could look similar to the one below:

Best,
Roberts // support@eazybi.com