Checkbox set help, please
Operating system version
Description of the issue
Hello all! I'm trying to create a report using checkbox sets. I'm not exactly sure how I should explain this, but I'll give it a go (kinda new to the whole FMP programming thing).
I have a checkbox indicating certification scopes for our clients. The checkboxes (5 values) can all be simultaneously checked at once or only one checkbox can be checked.
My problem is that I need to provide a report indicating, yes - the crop box is checked in one data field, no - the livestock box is not checked in another data field, and so on.
Steps to reproduce the problem
I've tried using the following calculation to get a yes/no result in a new data field:
If (not IsEmpty (FilterValues (ODAS::Certification Scope; "Wild Crop")); "Yes"; "No").
Even if "Wild Crop" is checked in OSDA::Certification Scope, then the new data field is still showing no, and I need it to show yes.