NON CUMULATIVE KEY FIGURE 0NUMWDAY

[Former Member]

Hi Gurus,

I am having a problem I can't solve with key figure 0NUMWDAY.

I have to calculate 0numwdays for each 0calmonth. 0numwday is not an attribute of 0calmonth, (in fact 0calmonth has no attributes) which is OK, because working days vary for companies, factory calendar and country holidays.

We have the routine ti get the exact number of days and working days for 0calmonth, and they go as a key figure for my Purchase Order Cube.

Now, when I create the query for amount of purchase order for a certain month, I need the working days to calculate the average.

But I get the working days summarized, when I need in fact only the working days NOT SUMMARIZED. I have tried different things, but haven't worked.

I need working days by ocalmonth, purchase doc type, position, record condition (- or +). When I define an infoobject as reference, I can only add ONE, when I need to add more!

Waiting for your help,

Kind regards!

[maxilopez]

Hi María,

I wanted to ask you if your concern was resolved.

Please, let me know if you need further help.

Regards,

-

Maximiliano

[Former Member]

Hi,

You can solve your problem using Exception aggregation on your keyfigure with reference characteristic as 0CALMONTH. You can create exception aggregation on the keyfigure which is already having one exception aggregation.

Regards

Githen

[maxilopez]

Hi María,

I think you can solve the problem by defining an exception aggregation to the key figure 0NUMWDAY.

You can do it at key figure definition or at query level.

For more information, you can check this links:

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d2/e0173f5ff48443e10000000a114084/content.htm

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/80/1a62f8e07211d2acb80000e829fbfe/content.htm

Hope this helps.

King regards,

-

Maximiliano