Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XL-Reporter : Monthly & Yearly

Hi! Hav anyone tried in getting monthly & yearly values in XL-Reporter?

For current day's detail of sales we can use,

FIG( SO_TaxDate = CurrentDate ), which works good.

similarly if i put

FIG( SO_TaxDate = CurrentMonth )

FIG( SO_TaxDate = CurrentYear )

it is not showing any values, but '0'

how can i get the monthly & yearly values similar to 'CurrentDate' ?

in case of year i hav to go for fiscal year which is frm Apr - Mar



Hi Meera,

If you filter your column selection by financial period where the Code = CURRENTPERIOD

Then for your year to date column selection you could filter by the financial period where CODE = YTD(CURRENTPERIOD)

I hope this helps, regards


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question