Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LYTD formula:
=if(
vOptionCurrency = 1 and vOptionPremium = 1, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(addyears(Max(TP_New_Month),-1)))) <=$(=date(addyears(Max(TP_New_Month),-1))) "}>}TP_NetPremium_LC_1),
if(
vOptionCurrency = 1 and vOptionPremium = 2, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(addyears(Max(TP_New_Month),-1)))) <=$(=date(addyears(Max(TP_New_Month),-1))) "}>}TP_GrossPremium_LC_1),
vOptionCurrency = 3 and vOptionPremium = 1, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(addyears(Max(TP_New_Month),-1)))) <=$(=date(addyears(Max(TP_New_Month),-1))) "}>}TP_NetPremium_LC_3),
vOptionCurrency = 3 and vOptionPremium = 2, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(addyears(Max(TP_New_Month),-1)))) <=$(=date(addyears(Max(TP_New_Month),-1))) "}>}TP_GrossPremium_LC_3)))))
YTD formula:
vOptionCurrency = 1 and vOptionPremium = 1, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(Max(TP_New_Month)))) <=$(=date(Max(TP_New_Month))) "}>}TP_NetPremium_LC_1),
vOptionCurrency = 1 and vOptionPremium = 2, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(Max(TP_New_Month)))) <=$(=date(Max(TP_New_Month))) "}>}TP_GrossPremium_LC_1),
vOptionCurrency = 3 and vOptionPremium = 1, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(Max(TP_New_Month)))) <=$(=date(Max(TP_New_Month))) "}>}TP_NetPremium_LC_3),
vOptionCurrency = 3 and vOptionPremium = 2, Sum({<TP_Year,TP_Month,TP_New_Month={">=$(=date(yearstart(Max(TP_New_Month)))) <=$(=date(Max(TP_New_Month))) "}>}TP_GrossPremium_LC_3)))))
Hi David,
Thank you very much..
