Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to get a field value to show in the column heading in a straight table. The column heading (AuxReasonDescription) is in the following table:
The following script works to get the "y" in the label but I can't get it to show the AuxReasonDescription instead of "y":
=if(count({$<AuxReasonCode={'1'}>}AuxReasonDescription)>0,'y','n').
Any help would be appreciated.
Try
=only({<AuxReasonCode={1}>} AuxReasonDescription)
That worked!! Thanks so much.