I would like to use the Business Calculation feature when creating a report and create a column that determines if a particular column contains a string that I specify.
Is this feasible?
Example)
■database: book
id name
1 book A
2 book B
3 book AB
■Business Calculation
・field label: contain A
・formula:
case(
When: book like ‘A’, then: ’true’,
else: ‘false’
)
id name containA
1 bookA true
2 bookB false
3 bookAB true