Boolean, lookup and lists

Options
rekaitis
rekaitis Member, ALL USERS Posts: 4 Occasional Contributor

I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't do that. So I moved on to thinking I need to use the lookup function, but I am at a loss on the syntax to ensure it is a specific value out of that list. 

 

Do I need a system module before I can do this? I need this populated so that I can then do a calculation only for the records that have this specific value.  

 

Thanks

Comments