Goal:
Create a global variable that can be placed in a background color expression without having to "hard code" the field name as the parameter. How to dynamically pass the field value being test from a table to another variable
Example:
Created fields called 'Margin' and 'Average' in a straight table. Would like to be able to create a global background color expression that can be called with a parameter. The receiving variable would receive the field name and return the color code back based on that value using an if condition.
Trying to replace with a variable and a parameter - =if((Average) > 0, lightred(),Green())
Thanks in advance for any solutions or suggestions