You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!