Dynamic Reference line for chart

[Bran-d]

I want to add logic to my reference line in a chart where if somebody selects X, Y, or Z within the filter APPN, then display Max([Obligation Benchmark %]) as the reference line, but if none or more than one of the filter options are selected, then do not show the reference line. Can someone please write out how this should look when inputting into the reference line expression editor?

[Mark_Little]

Hi @Bran-d 

Probably something a long the lines of

IF( GetFieldSelections(APPN) = 'X' OR GetFieldSelections(APPN) = 'X' OR GetFieldSelections(APPN) = 'Z' ,

Max([Obligation Benchmark %]) )

[Bran-d]

Worked like a charm, thanks so much!!