Question about using variables in Experience Designer Data Grid

Lidia

Hi,

I am working on an application in Infor Experience Designer and I have a question about how variables can be used with a Data Grid.

I created a variable of type Calculation and I would like to use its value to control what is displayed in one of the grid columns.

For example, depending on a flag or condition, I would like one column to either:

• display the real value returned by the data service, or
• display 0 instead

I tried using the variable in the Data Grid Conditional Styles, but the variable does not appear there as an available field.

My questions are:

1. Can a variable created in Experience Designer be used directly in Data Grid Conditional Styles?
2. If not, what is the recommended way to conditionally display 0 in a grid column based on a variable, field in other component or calculated condition?
3. Does a Calculation variable support IF/ELSE logic, and if yes, what syntax is supported?

Any guidance or example would be appreciated.

Thank you.