on 11-06-2007 9:18 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
97 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.