Dynamic Variable for last day of month

[Former Member]

Hi all,

I have created one report where in YTD is calculated based on stsyem date. NOw in this report the cal month is in row thus displaying data month wise. But i need one key figure which giving the last day vaue of every month that are displayed in YTD i.e this is based on cal day. Thus the report layout is as follows:

if report is run in mar 2007 then it should display:

calmonth key figure due amount

Jan 07 this should show due value on last day of jan 07 (i.e 31st jan 07)

Feb 07 this should show due value on last day of feb 07 (i.e 28th feb 07)

Mar 07 this should show due value on last day of mar 07(i.e 31st mar 07)

customer exit variable can give me only one value at a time. How can I make it dynamic to take last day value of every month as per cal month. Could anybody explain me if worked on any such issue.

If there is some how to paper kindly mail me at my email Id : dearwrushali@gmail.com

thanks in advance

Regards,

Wrushali

[Former Member]

Hi,

We can assign multiple single values to the customer exit.

So in the Query take CALMONTH in rows.

And take your KF in column with Customer exit variable restriction on CALDAY.

So in the code of this Cusotmer exit varible, from the Current date find out the year of the current date and then assign those 12 required days to this variable.

With rgds,

Anil Kumar Sharma .P