How to handle an empty value in a report

Templates Reports
1

We use reconciliations.kredieten.results.totaal_kapitaal in our report, but the reconciliations.kredieten reconciliation is no longer in use for new companies, while it is still in use for older companies.

Because there is no value for reconciliations.kredieten.results.totaal_kapitaal in those cases, the report can’t calculate the sum. So I would like to place a default zero value if there is no reconciliations.kredieten.results.totaal_kapitaal value.

If I use reconciliations.kredieten.results.totaal_kapitaal default: 0 in the formula, the report displays a zero, but also for the periods of the older companies who do have a value for reconciliations.kredieten.results.totaal_kapitaal. So that’s no good. How can I solve this?

In general, I would like to use something like IF(ISBLANK(reconciliations.kredieten.results.totaal_kapitaal); 0; reconciliations.kredieten.results.totaal_kapitaal) in the formula bar of a report.

2

Hi @Maarten ,

Sorry for the late reply!

What do you mean exactly with ‘the report can’t calculate them’ - do you see a warning or does it just doesn’t sum with other numbers?

Thinking about the default is the correct way of thinking I think, but instead of adding the default in the report you should probably add this default in the kredieten template where the result is created, so that the result always has a numeric value.

Hope this helps!

Kind regards,

Robin