Focal Point
PMF - TIME RANGE : YTD vs prior YDT

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/8957004026

May 21, 2012, 10:06 AM
Carlos Da Costa
PMF - TIME RANGE : YTD vs prior YDT
Hi,

Do anyone knows, if it's possible to create a :
YTD vs prior YTD.

In PMF there are :
-YTD vs prior (but it take all the previous year)

-Quarter vs prior (but we have to build 4 reports)


I've try to build "YTD vs prior YTD." but it seem impossible to have two discrete time value which ends values are according to the current time.

Example, the current date is 05/2012 :
We want : 01/2011 -> 05/2011 vs 01/2012 -> 05/2012.

Any ideas ?


Thanks,


Carlos (PMF 5.2.3 HF4)
May 22, 2012, 07:12 AM
Bob Jude Ferrante
Carlos,
The PMF data extraction pass only pulls data over continuous ranges.

To get what you want, you'd need to do two time ranges; one for current year YTD to current point in time; a second for prior year YTD to this point in time 1 year ago,

then perform the extraction twice,

then merge the results of these two to produce your final report.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!