How to check if an OptionSet in a CRM field has a certain value

Hi All,

 

I have to check if a value is contained in an OptionSet of a field in CRM Online.

 

Is there a way to do this utsing the LOOKUP function ?

 

Something like this :

 

 

LOOKUP(account.revenue,"500-1000")

 

 

Where "account" is the table and "revenue" is the field that contains the OptionSet.

 

 

Cheers.

 

Stefano

(3) Answers

Login