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

Display Month when RKF =0

Hi everybody

I'm building a Quality Notifications (QN) Report for the last 12 months that will be run for one Vendor at the time. I have a Restricted Key Figure [RKF](using an Item Counter RKF pre-built by our company) that is counting how many QN's a supplier have for a given month, and returns the result. My problem is that if there is no QN for a specific Month, the Month won't appear in my report since my RKF is not returning a "0 value" if nothing happens. I need a fast way ('cause I want this report to run in less than 20 sec) to force my RKF to display the month, even if no QN's have been raised... Have any sugesstions?

Eric L.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2005 at 10:00 PM

    Hi Eric

    I was able to do something similar to this and get the month to display even though there was no data for a particular month. The way you can do it is to create a new restricted key figure in your query, restricting the existing rkf by one month. If your report lists a rolling year, you can accomplish the results by creating 12 new rkf's in the query restricted on current month, current month-1, current month -2, etc. If your report lists a full calendar year you can accomplish this by using the variable last month booked of previous year + 1 to give you Jan, last month booked of previous year + 2 to give you Feb, etc. When you create your new query rkf's, if you use &ZCMTHTX& in the description of each new rkf, when your run the query the correct month name and year will be displayed.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Eric,

      Other options that you may want to consider:

      1. From what you write, I assume that you have a Counter KF (=1) at your disposal. You can add this to your quey definition and the hide it. If you do not have a counter, use any KF where you know that it will definitely have a value in all months.

      2. Alternatively, you can also create a 12 month structure with 12 selection for calmonth and variable offsets.

      Hope this helps...

      Bhanu

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2005 at 11:29 PM

    Check out the How-to Paper: How to…

    Display Unposted Values as Zero Values in Reporting.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 10:27 PM

    Eric,

    Be sure to reward Roberto for his alacrity ;>

    Manish

    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.