Skip to Content

Report : Display 0 where Blank

Hi, i have requirement in my report for some of the keyfigures i need to display 0 where it is blank.

in the report we have enabled Masterdata results for all the characterstics that means they will display when there is no posted values in that cases need to dispaly 0 instead of Blank.

Please let me know if anyone has sol.

Thanks,

Kalyan

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 10, 2010 at 08:41 AM

    what we did:

    let's say you want to do this for KF1.

    create calculated key figure with defintion : KF1 + 0

    then use the calculated kf in your query. it will always show 0 instead of blank.

    M.

    Add a comment
    10|10000 characters needed characters exceeded

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.