Use formulas in reports

Templates Reports
,
1

Hi

I am trying to create a report with, at the end of the report, the result of a formula.
This formula must check two criteria in order to show a certain result (like ‘Ok’ or ‘Not ok’).
For example, if criteria A is ‘Ok’ and B is ‘Ok’, the result should be ‘Ok’. If not, is should be ‘Not ok’

Can I add an if-formula in a report or is there a workaround?
I know there are four edit characters (+, -, / and *).

Thank you in advance.
Henri-Louis

2

Hi @Henri-Louis,

Thank you for your question!

Unfortunately, it is not possible to use the control flow tags in the formula box of the report. You can call upon the result tag using the code below:
reconciliations.handle.results.name_of_the_result_tag
but this will only work for the numeric values.

Please let me know if you need any further assistance.

Kind regards,

Irina