expression

[smilingjohn]

HI All,

Expertise please havea look .

i want to get from today to back 2 years ..

is this correct expression ..

count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate))"}>} ID),

Count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate)-1)"}>} ID)/12,

Count({<[Dept T]={'A'},PaidDate={"$(=Max(PaidDate)-2)"}>}ID)/12)

if this is wrong then please correct ..

and the output should be like the way shown in screenshot

Thanks in advace

[Anil_Babu_Samineni · Accepted solution]

You can try with. First try in text object using 2 diff expressions and then have a look in report

count({<[Dept T]={'A'},PaidDate={">=$(=AddYears(Max(LoadDate),-2)) <= $(=Max(LoadDate))"}>} ID)

[vikasdesai]

Hello

Use following Expression

count({<[Dept T]={'A'},PaidDate={">=$(=Yearstart(Max(LoadDate),-2)) <= $(=Max(LoadDate))"}>} ID)