Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends !
i'm having a doubt in applying set analysis for calculating the claims paid of year wise.
Here is my expression
Sum({$<year={">vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1)
my output should be
year ClaimsPaid
2014 324.23
2013 452.12
2012 325.23
Is there any mistake in my expression? please anyone help me out.
Regards
Krsh
Hi Krish
May I know the clear requirement. You want to see the output for past three years claims right?
if u want like above requirement please find the below expression it will helps you
=sum({$<Year={'>=$(VPrevsecondYear)<=$(VMaxYear)'}>}CE_AMT_LC_1)
Variables:
VPrevsecondYear=max(Year(date(Datefield,'DD-MM-YYYY')))-2
VMaxYear=Max(Year(Date(Datefield,'DD-MM-YYYY')))
Hope this will helps you
Try Sum({$<year={">=$(vCurrentYear)-2<=$(vCurrentYear)"}>}CE_AMT_LC_1)
Hi,
try this
sum({<newyear={'$(=max(newyear)-2)','$(=max(newyear)-1)', '$(=max(newyear))'}>}Sales)
If you are using a variable then replace max(newyear) with it.
HTH
ravi n.