help in set expression

[#1]

Dear All,

Good Evening, as I have a expression = Count({<WEEK={'$(=max(WEEK))'}>} NBofINVOICE), its upto last year it was worked fine.

But now I have a issue and its showing wrong data, I think its not taking the latest year.

Please help me.

Regards

Joe

[lironbaram]

try something like

Count({<WEEK={'$(=max({<YEAR=max(YEAR)>}WEEK))'}>} NBofINVOICE),

[#3]

Dear All,

I am not clear about the previous question, Using a text box object I am trying to dispay the Last WEEK NBofINVOICE, so I tried like this = Count({<WEEK={'$(=max(WEEK))'}>} NBofINVOICE),

Now I have a problem in displaying the last week value, I tried to add the

= Count({<YEAR={'$(=max(WEEK))'}>} NBofINVOICE), but its not helpful.

can you please help me...

Regards

Joe

YEAR	WEEK	NBofINVOICE
2011	49	5
2011	50	11
2011	51	10
2011	52	17
2011	53	8
2012	1	11
2012	2	7
2012	3	10

[SunilChauhan]

try this

Count({<WEEK={$(=max(WEEK))}>} NBofINVOICE)

or

this also work

Count({<WEEK={$(=max({<YEAR=max(YEAR)>}WEEK))}>} NBofINVOICE)

hope this helps

[#5]

Hello Sunil,

Thanks for your reply, I tried but still its not comming. its taking only the 53rd WEEK.

My requirement is it should take the value of  2012 2nd WEEK value.

Regards

Joe

[lironbaram · Accepted solution]

ok

this should work

=sum({<WEEK={"$(=max({<YEAR={"$(=max(YEAR))"}>}WEEK))"}>}NBofINVOICE)

attach is also an example

[#7]

Dear Liron,

Thanks a lot, excellent.....

I will try this and update you tomorrow.

Regards

Joe