Hi Kathy! I find the easiest way is using the trick of parent intersections showing zeros by changing mapping from something like Value to "Total Value" which is just a parent of value.
If you are using MDRs you can also uncheck the "Treat Zeros as Blanks" check box
Hope that helps
------------------------------
Liam Gordon
Consultant
Vena Solutions
------------------------------
Original Message:
Sent: 12-01-2023 10:58
From: Kathy Pethers
Subject: Display of null values in reports (without Office 365)
Does anyone know if it is possible to display null values as zeros in reports? We have null values at some intersections of bottom level members, and this data gets displayed as blanks in Excel. Not sure it it makes a difference, but we are not yet on Office 365.
I can see that Vena sums nulls at parent level members and returns a result of zero, hence those display as zero (reference YTD period members.)
------------------------------
Kathy Pethers
Financial Plus Credit Union
------------------------------