General Discussions

 View Only
  • 1.  Display of null values in reports (without Office 365)

    Posted 12-01-2023 10:58
      |   view attached

    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


    null value display.docx   100 KB 1 version

  • 2.  RE: Display of null values in reports (without Office 365)

    Posted 12-04-2023 10:31

    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
    Vena Solutions