I'm having a problem in reloading data.I.e; i;m having four companies data.
for EG A,B,C,D
A data reloads on 05/july/2014
B data reloads on 10/July/2014
C data reloads on 15/July/2014
D data reloads on 16/July/2014
I have to find out the LYTD.I did for it.I'm getting data exactly when selecting the company particularly. But when the application is cleared the data showing wrongly.its taking as Max date of reloaded and its showing data on for 16/july/2014.How can i show the data correctly when the application cleared also.Here is my expression.Please anyone could suggest me how to resolve this.
=if(
vOptionCurrency = 1 and vOptionPremium = 1, Sum({<TP_APPR_DT={">=$(=num(yearstart(addyears(Max(TP_APPR_DT),-1)))) <=$(=num(addyears(Max(TP_APPR_DT),-1))) "}>}TP_NetPremium_LC_1),
if(
vOptionCurrency = 1 and vOptionPremium = 2, Sum({<TP_APPR_DT={">=$(=num(yearstart(addyears(Max(TP_APPR_DT),-1)))) <=$(=num(addyears(Max(TP_APPR_DT),-1))) "}>}TP_GrossPremium_LC_1),
if(
vOptionCurrency = 3 and vOptionPremium = 1, Sum({<TP_APPR_DT={">=$(=num(yearstart(addyears(Max(TP_APPR_DT),-1)))) <=$(=num(addyears(Max(TP_APPR_DT),-1))) "}>}TP_NetPremium_LC_3),
if(
vOptionCurrency = 3 and vOptionPremium = 2, Sum({<TP_APPR_DT={">=$(=num(yearstart(addyears(Max(TP_APPR_DT),-1)))) <=$(=num(addyears(Max(TP_APPR_DT),-1))) "}>}TP_GrossPremium_LC_3)))))
