Date format

[krishna20]

Hi Friends,

I'm having problem in date format.

=sum({$<TP_MONTH={$(=MAX(TP_MONTH)))-12)},TP_YEAR=,TP_MONTH=>}TP_GROSS)

I'm having in datamodelling TP_MONTH as JAN,FEB,MARCH,APR.....

How can i take in set analysis as 1,2,3..........

Can any one pls provide sample one..

Regards

Krishna

[#2]

Hi,

No I used dates but I think you get the result you want.

Use the expression I gave you in a straight table with Year and month dimensions. then you can add your expression and compare the results.

cheers,

David

[krishna20]

Hi David,

Thank you for ur expression,i got nearest value.But i need to compare the with the month.can you pls suggest me where i can include this month expression in the above expression.

Regards

krishna

[#4]

you need to modify the script for that,

I suggest you to add a field monthstart using TP_APPR_DT field

You can add this to your script:

New_Policy_Calendar:

load *,

monthstart(TP_APPR_DT) as New_month

resident Policy_Calendar;

drop table Policy_Calendar;

then you can use the expression I gave you or something similar,

Cheers,

David

[krishna20]

Hi david,

i did wat u suggested me..But the result is same before creating the calender table.

Regards

krishna

[#6]

can you attach your new model?

[krishna20]

Hi David,

Pls find the above attachment. and guide me further.

Regards

Krishna

[#8]

Sorry I don't see the new month field, but anyway, can you tell me why my formula is not ok?

[krishna20]

Hi David,

actually i need to get the result for 2013 for july 22.i need to compare month also here(LYTD).

Regards

Krishna

[krishna20]

Hi David,

Here is file updated file with a field TP_NEW_MONTH.

Pls find it and guide me.

[krishna20]

Hi David ,

The file is not opening can you please upload once again.

Regards

krishna