Offset in Text Vairabel "&ZCMC&-1"

[Former Member]

Hi All,

I have created 12 keyfiguer, for each i required to show field heading as last 12 month respectively like 09.2009..............07.2010 08.2010.

I have created one text variable &ZCMC& which gives calander month value ex: 08.2010 which is calculate using replacement path on calandery year month,

now i required to do &ZCMC&-1 so that i can get one month back value ex: 07.2010 and so on..., is there any syntax or workaround?

Dushyant.

[former_member189638 · Accepted solution]

In Formula variable with type replacement path itself you ca do the offset setting.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/03/6ba03cc24efd1de10000000a114084/content.htm

[Former Member · Accepted solution]

Hi,

I am using replacment path on calnder year month variabel, from variabel i am getting only one month value ex: 08.2010, which i am showing at text variabel of 12th keyfiguer text, now how to get this value for rest key figuer text heading ?

ex: 1st keyfiguer text 09.2009, 2th key figuer text 10.2009....11th key figuer text 07.2010.

Regards,

[Former Member · Accepted solution]

Hi Dushyant

Please can you clarify below:

1. Why 12 Key Figures are required to display Monthly Data. Will Month and the Key figure (say Amount or Quantity) in the Columns not produce the same layout as you were expecting?

2. If Each of them is a RKF with an offset value -11 to 0, using the same Text Variable should solve the issue. Isn't it?

This works if the text variable is a customer exit copied from the entered value for month. Alternatively, if you have SAP Exit Text variable from the manual input characteristic variable used in the query, it should work.

Sri

[Former Member · Accepted solution]

Hi Sri,

> This works if the text variable is a customer exit copied from the entered value for month.

yes we can do this by customer exit text variabel which copied from entered month value, but we have to create 12 customer exit variabel and code for that, 12 time code will harm performance.

> Alternatively, if you have SAP Exit Text variable from the manual input characteristic variable used in the query, it should work.

can u elobrate this what u inicating? my requirement to show current month and current month -1 and so on at each 12 keyfiguer text variabel.

I need 12 static keyfiguer which have text heading as month and than i am using cell editor for calculating each cell diffrenty.

[Former Member · Accepted solution]

Hi Dushyant

I understand thet you need to show 12 months rolling period data for the given month.

This could be done in two ways:

1. Using the Characteristic Month in the Columns, so all key figures are repated for each month for past 12 months

As the month always appears above the Key Figure (or below depending on the Choice of design), a text variable is not required at all

2. Using RKF for each month.

This is when you will need the Month number / text to be populated.

Create a Text Variable using replacement path for Cal Month with Replacemenet of InfoObject and value as Label

Restrict each key figure with corresponding month using Offset for the Variable -11, -10, etc to -1, 0.

This will automatically populate the month for which it is displaying the data.

Let me know if this has answered your query

Thanks

Sri

[Former Member · Accepted solution]

Hi,

Thanks sri,

Ya its working, perfect, i used current cal month with offset, i was using formula instead of RKF,i did same long time ago.

Thanks.

Now i required report result "total" breakup for each of this 12 keyfiguer

If u can answer to my this thread: How to show Report Result line breaked(or seprate) into Total AVG MAX MIN?

Regards,

Dushyant.