Skip to Content
0
Former Member
Nov 05, 2012 at 10:18 PM

YTD Calculation

33 Views

Hi,

I have developed first report successfully with the below layout (Fiscal period with single value as mandatory):

Actuals YTD_Actuals Budget YTD_Budget

Char 1 Char 2

Now the user is asking for the similar layout as (Fiscal period with Interval value as mandatory):

Actuals YTD_Budget

Char 1 Char 2

If the user runs FISCPER from 001/2012 - 004/2012 and the results should show for actuals as

Actuals (001/2012) Actuals (002/2012) Actuals (003/2012) Actuals (004/2012) YTD_Budget (from 001/2012 to 004/2012)

Char 1 Char 2

Where as YTD Budget should pick the highest FISCPER from the selection and display YTD Budget calculation from 001/2012 to 004/2012 into one column.

Can this task be done in one report? Please provide your expert opinions.

Thanks,

Panadu.