multiple conditions in Set analysis

[krishna20]

Hi Friends,

I'm having a doubt in applying multiple conditions in set analysis.can anyone pls help me out.

my expression is

=count({<CLM_CR_DT={$(=vCurrentYear)}>}+Count({<CLM_CR_DT={$(=vCurrentYear-1)}>}+Count({<CLM_CR_DT={$(=vCurrentYear-2)}>}CLM_NO))).

I have to get the output as

year count(CLM_NO)

2014  23

2013  34

2012  53

Please let me know, is there any mistake in my expression ASAP.I'm not getting any output.

[krishna20]

Hi Ram!

The same result i'm getting.is there will be any other issues in this?

Regards

Kalyan

[MayilVahanan]

HI

Can you provide a sample file?

[krishna20]

Hi Ram!

I'm unable to find advanced editor to upload this file.can u please provide ur mail ID.

Regards

Kalyan