Complicated report

[peterberlin]

hello
we have our own entity with these fields:
"Field A" and "Field A ready" (yes or no)
"Field B" and "Field B ready" (yes or no)
"Field C" and "Field C ready" (Yes or no)

Field G (yes or no)
Only fields A, B or C should be listed in the report, if field G = no and the respective "field ready" = no.
Can you do something like this with espo? I couldn't find a way to do it in the report.
peter

[tanya]

Hi,
I think you need to create new fields, which return the value, if "field ready" = no , else return '';

https://dev.mysql.com/doc/refman/8.0/en/control-flow-functions.html

https://forum.espocrm.com/forum/general/34663-report-filter-for-comparing-values-of-2-float-fields

[peterberlin]

thank you.
But it's too complicated for us. We'll find another way.

[tanya]

Also you can create this fields and set with workflow and formula, as usual. But you need additional fields in any case