I have a crosstab that displays financials over three time periods (year, month, week) this is the first column group. The next sub column group is actual vs forecast. The aggregate column for this takes max(field.value) - min(field.value) to determine the variance between actual and forecast.
I need to figure out either how to conditionally format this field to show whether the variance is favorable or unfavorable (probably with color)
I need to write the expression to subtract
(fields.value Where fields.type = actual) - (fields.value Where fields.type = forecast)
with this the result would be negative if unfavorable.
Basically I need to create case or switch statements for conditional formatting and format string values can this be done either through the expression editor or through the backend C# code behind page.