ITE not picking up lookups as things to use

I am trying to get an ITE working – based on a math column being bigger than a value from a lookup (or single value).

I thought this used to work, but now I am not able to use the lookup or sv column in the ITE editor :frowning:
This makes me… sad.

Are you sure that lookup is coming from a single relation and not a multiple relation?

The single-value (SV) I want to use is a single value, looking up against a table to pull in the first result (sadly)

Are you sure all your values are numeral?

Genius!

GS thought they were numbers and formatted them as numbers…
but Glide had turned them into Text Columns.

Fix applied - thanks!

1 Like