Relevant using (and, or)

Support
2

Hi @Dada

Please attach the XLS form so that someone in the community can try to help.

Thanks

3

EOCODKcycle4.xlsx (31.4 KB)

4

Hi @Dada situation is that relevant was mistyped as relevance.

On the other hand, I think second part of your formula is unnecessary "or (reverselog1<=0 and reverselog2 <=0)". It would be enough with if (reverselog1<=0 or reverselog2 <=0)

1 Like
5

i corrected relevance to relevant and use only one line of note with relevant if (reverselog1<=0 or reverselog2 <=0) but it only shows wen either reverselog1 or reverselog 2 is less than zero not when both are less than zero. EOCODKcycle4.xlsx (31.2 KB)

6

Hello,
In your xlsx you have the opposite: ${reverselog1} >=0 or ${reverselog2} >=0. This might be the error?
Based in the given the OR is working ok, see stripped example.
EOC Test01.xlsx (12.4 KB)

Side-note: Note normally does NOT have a required attribute (as no input possible). Do you want to block the flow with this? (You might show another required_message? Or use acknowledge type - required, plus constraint.)
Kind regards

7

yes the problem was from the < sign. @wroos the form is supposed to stop if there is a negative value hence the need relevant and for reverselog to be note so that the user will not have any selection to make reverse log is a calculated value which checks how many drugs were given-drugs used to get the balance of drugs to be returned thats why is has to be a positive value.