How to put if statement dimension in drop down variable input box

[Femke_DPG]

Hi all

How can I put an if statement (dimension that is not defined in the load editor, but made by an if statement in the sheet) in a drop down input variable? 

When I put the if statement in the 'value' field, it does not work.

The if statement is depending on the selected year: if the selected year in the filter is this year (2022), then "negotiation status year", otherwise [Negotiation Status Next Year]:

If($(=getfieldselections(Year))=Year,
[Negotiation Status Year],
[Negotiation Status Next Year])

I put that if statement in the drop list, but I get '-':

Thanks!! 

[sidhiq91]

@Femke_DPG  Could you please post sample data and also expected output?