Using variables in conditional formats

If you use a variable in a conditional format (for example, ..\users\public\documents\infor\bi\olap\databaseroot\single\[database_name]), the format does not change when the value of the variable changes. The format changes only when the report is recalculated.

A solution is to insert the variable into any cell in the report (for example, in a hidden column or row) as well as in the condition. The format changes immediately when the value of the variable changes, without recalculating the report.