Journal Workflow Spreadsheet AND and OR notations
I want to use an 'AND' and 'OR' statement, what notations should I use in the Journal Workflow Spreadsheet. The BPM UI is no longer available.
There is no clear documentation on this, at least I can't find it. I have found '&&' or '|' for AND, and I found '||' for OR but nothing seems to work.
The rule is simple the segment 2 values (alphanumeric) in the COA are NOT IN (account x, y and z) AND smaller than 400000.
The 'NOT IN' part works fine, however the AND part is not working as expected.
Anyone an idea what notations to use?
0