Please help me calulate the YTD in the WEBI report?

[Former Member]

Can you please help me calulate the YTD in the WEBI report?

My requirement is that I get the Posting Date and the Fiscal Year from R/3. The user is interested in seeing the data YTD.

The Fiscal Year start from APRIL to MARCH each Year.

Thanks In advance..

[IngoH · Accepted solution]

Hi,

I assume your data source is a BW query and if so then the easiest way to achieve this would be to create an EXIT variable.

Ingo

[Former Member · Accepted solution]

Thank You mates for your valuable suggestions.

However, I achieved that through variable functions in WebI.

-Deepinder

[Former Member]

Thanks!!

[Former Member]

Hi ,

1.If bi is integrated with bo then you create YTD variable using customer exit as processing type in BEX report and use this variable in WEBI Report.

2.You create one variable for start of the year by using concatenation function("1/1/2010") and create on variable for current date and use the between function in the prompt in the webi reports.

Hope it will give some idea.

Regards,

Ramnaresh.P.