XL-Reporter : Monthly & Yearly

[Former Member]

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

Meera.

[Former Member · Accepted solution]

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

Adrian

[Former Member · Accepted solution]

Thk u Adrian! thts working fine...

Meera.