Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ok
this should work
=sum({<WEEK={"$(=max({<YEAR={"$(=max(YEAR))"}>}WEEK))"}>}NBofINVOICE)
attach is also an example
try something like
Count({<WEEK={'$(=max({<YEAR=max(YEAR)>}WEEK))'}>} NBofINVOICE),
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 |
try this
Count({<WEEK={$(=max(WEEK))}>} NBofINVOICE)
or
this also work
Count({<WEEK={$(=max({<YEAR=max(YEAR)>}WEEK))}>} NBofINVOICE)
hope this helps
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
ok
this should work
=sum({<WEEK={"$(=max({<YEAR={"$(=max(YEAR))"}>}WEEK))"}>}NBofINVOICE)
attach is also an example
Dear Liron,
Thanks a lot, excellent.....
I will try this and update you tomorrow.
Regards
Joe