Hi,

I wish to compare single-value entry in a field to text value or another single entry field. In result, I wish to receive the value of a multi-value field. For now I am able to do so using boundary values to define a single-entry field.

I.E. where D.Country is a multi-value field.

IIF([BCountry].[Value]="Iran",[DCountry.Value],[BCountry.Value])

I would appreciate any observations.