Skip to Content
0
Former Member
Jun 05, 2008 at 10:18 PM

use FI Posting date as a filter value, can I get YTD for current year?

67 Views

Dear Expert,

I work on a BI report which calculate the YTD key figure (restricted by 0CYEAR and =< 0CMONTH).

One of the requirement for the report is to allow user to enter a value for a date using FI Posting date (although this is optional).

Without entering the value for FI Posting date, my report works fine.

But once FI Posting date is entered, no data found.

I expect that when the value for the FI Posting date is entered, the YTD value will be calcuated starting from the Jan 1 of that FI Posting year to the FI Posting date entered.

But this seems not happen.

Could you help me to resolve this problem?

If there is a better solution, please let me know.

Very appreciated.

Arthur