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

Femke_DPG — Tue, 25 Oct 2022 10:37:28 GMT

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!!

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

sidhiq91 — Tue, 25 Oct 2022 10:34:44 GMT

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

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

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

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