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.)
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
Forum brought to you by Vena Solutions Inc.