Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to create a report in Nprinting with 4 dimensions and several expressions.
So in Nprinting I created 4 levels for these dimensions, and formulas for each needed field containing "=only(fieldname)".
Attached a snapshot of the report design.
The problem is that we might not have all levels filled, in which case the rest of the columns are not being displayed although they contain values.
If all levels are filled, then we get all the values in the report.
Can someone suggest how to solve this please ?
Thanks.
I actually solved this by creating a formula by level by field (so in my case, 4 formulas for each field).
In the formula, I check if the subsequent level is null or not to actually know if the value should be displayed on this level or the next one:
example:
Comment_Level3 = if(isnull(Level4), if(isnull(Comment), '', Comment), '')
I don't know if that's the optimal solution, but it could be helpful to someone who's facing the same.
Or if someone could share a better solution, this would be great.