cancel
Showing results for 
Search instead for 
Did you mean: 

Display Month when RKF =0

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Eric,

Be sure to reward Roberto for his alacrity ;>

Manish

Former Member
0 Kudos

Check out the How-to Paper: How to…

Display Unposted Values as Zero Values in Reporting.

Former Member
0 Kudos

Manish

I went to the HOW TO section and I Cant' find this How To guide.... Is there a way that you can email it to me at eric.longpre@pwc.ca?

thanks in advance

Eric L.

Former Member
0 Kudos

Hi Eric,

I'm sending you the required doc...

Bye,

Roberto

Former Member
0 Kudos

Hi Roberto,

I have similar problem displaying characteristics when key figure = 0. Can you send me the document you mentioed "How to...Displya unposted values as zero values in reporting" to me at eliang@abeam.com. Thanks a lot.

Former Member
0 Kudos

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.

former_member188975
Active Contributor
0 Kudos

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