Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parallelperiod/prevmember functions

Status
Not open for further replies.

Revelator80

Technical User
Jul 14, 2010
14
GB
Hi,

I followed the IBM instruction for creating a YTD data item for my reporting purposes, which is working well. However, I want to be able to implement LAST YTD and similar functions. Whenever I try, using either the parallelperiod or prevmember functions (as these seem most useful) I get errors.

My data source is DMR and, as prescribed by IBM I have data items for selected month (just sets the parameter), year to date set: periodsToDate([DW_Present].[Time Information].[Time].[Financial Year];[Selected Month]) and finally the data item for the spend YTD: (total([Evidenced Spend] within set [Year to Date Set]))

My assumption is that I would need to edit one of these to get last YTD. Any advise would be gratefully received.

Cheers
David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top