Boolean, lookup and lists
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.