Skip to Content
0
Former Member
Mar 27, 2007 at 01:37 PM

Dynamic Variable for last day of month

33 Views

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