Hi there,
I have a bit of a weird situation and I'm hoping someone will be able to help.
Right now I have a straight table with multiple columns that have conditional formatting to show different columns based on a selection. The code for this is:
if(isnull(GetFieldSelections([Rule Description])), 1, 0) // Always shows column if no selection is made
OR
if(wildmatch(getfieldselections([Rule Description]),'*1)*'), 1, 0) // Shows column if selection is like 1)
OR
if(wildmatch(getfieldselections([Rule Description]),'*2)*'), 1, 0) // Shows column if selection is like 2)
This is working as intended, showing or hiding the different columns based on the [Rule Description] selection.
The problem I'm having now is getting the columns to also show or hide if the [Rule Description] column only has one DISTINCT value in it.
For example:
If someone makes a selection of a different filter ( [Code Center] ) and the selection filters the data to only have values of "1)....", I would also like to show the columns as if the [Rule Description] "1)....." was filtered upon.
Anyone have any ideas on what I can do to get this to work? I have tried FieldValue() but I could not get it to work as intended.
