You’re offline. This is a read only version of the page.
Announcements
1
Can someone give me a hint how to create a FX formula to have a boolean result
I have a field with a choice type of ch_CompanyServiceKind when this kind has 3 kinds
FullProductKind
AssembleKind
ConsumerKind
In the table definition i have a Field CompanyServiceKind with the choice type chCompanyServiceKind
I want to have a FX boolean field
I have something like this
I believe you need to change you "IN" operator to an "=" operator and compare the column to the available options of the column. No need to reference the global optionset directly. Yes/No columns should also be defined by the [Column Name].[Yes/No]
example:
If( ThisItem.CompanyServiceKind = CompanyServiceKind.ConsumerKind , [YourYesNoField].Yes , [YourYesNoField].Yes)
Note that you can set formula columns to Yes/No fields, but you won't be able to set them to Choice fields
Share
Report
All responses (
Answers (
