Skip to Content
author's profile photo Former Member
Former Member

Zero / Space display for values in Financial Reports

Hi all,

We have a number of Financial reports using 0costelmnt in the rows and various 0amount restricted key figures in the columns. These reports are set to display zeros, however we have an issue where zeros are not being displayed consistently.

For example, for the same cost element a row may display a zero in the 'Actual 0amount' column but then a blank in the 'Budget 0amount' column rather than a zero. These reports also include YTD, LY etc KFs so there ends up being a confusing variety of zeros and blanks displayed even in the same row.

Now, I understand that I can define a forumla KF that will force a zero to be displayed, but my question is why do I need to do this ? Why, given that 0amount is a number, am I getting a mix of zeros and blanks displayed ?

Many thanks,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2008 at 10:36 AM


    You need to understand that space represents that there is no valid entry or no value existing for that character for that restrictions.

    this mainly happens if your report is based n multiproviders or you have restricted KFs.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Blair,

      I kind of disagree with your logic here.... The reason the restricted key figure returns blank is because there is no value associated to the set of characteristic values used in the restriction. It is Not because they are zero.

      So, if you want to see the No values as zero you can use the calculated KF approach to add zero to the null value.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.