If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calculating YTD with Relational data

Started by leahmarie, 03 Oct 2011 11:17:02 AM

Previous topic - Next topic

leahmarie

Hey guys,

I have taken a stab at this, but I seem to be stuck.  My problem is that I hate using relational packages but anyway -  I am trying to calculate YTD amount based on a prompted period which has YYYY-MM, but the data type isn't date/time it is characterlength 16; so none of the date functions are working.  I even tried starting with just pulling Prior Period(month) but no luck there.  I've used extract, add_months, <=?month? to get months in the year by trying to extract the year, and also _round(?month?/100, 0) and none of it is working. 

I would try to use another item that has data type date/time, but this one is required.

Any suggestions would be greatly greatly appreciated!!! ;D

Thanks!!


MFGF

Hi,

You might find it more straightforward to convert the item to a date datatype using the _make_Timestamp() function - you can plug in the year and month from your parameter and specify 1 as the day part.  This should then enable you to use all the nice date functions :-)

Regards,

MF.
Meep!

leahmarie

Thanks so much for the reply! I will definitely try that.:)