Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am short of idea, please help with your productive brain. i have some claims nos with multiple trasaction dates. i will have to calculate the current status(from status field based on Maximum transaction dates). then i will have to show those CLAIMS whose current status is say 2 .
So basically its filtering. Can't do at backend because its selection dependent(for till date analysis).
Thanks&Regards,
tresesco
Hi Tresseco,
Try this
=count({<[Claim no.s]>}distinct(@_Transdate)) as status
Regards
Sunil
Thanks Sunil for your response. I probably could not explain properly wht i want. please find the sample data attached. Here for selection assume that the max year selected is 2003. then for the current status, ID-1 status would be 2 (corresponding to max date -2/2/2002), similarly for Id - 2 current status 3, and for Id -3 it is 2.
Now at the front end i want those Ids whose current status <>3 (as dimension in chart). Everything should be at the front end.
Once again. Thanks for your time
Hi Tres,
At first you need to create a variable & an input box .This variable you need to use in the set expression like this
count( {$<ids,var1<=year>},distinct(transdate))
here is year=year(transdate)
Regards
sunil
Please go through it, if this can give you a better idea about what i want. Ids | Dates | Status | Amount | ||||||||
1 | 1/1/2002 | 1 | 100 | ||||||||
1 | 2/2/2002 | 2 | 200 | ||||||||
1 | 1/1/2001 | 3 | 300 | ||||||||
2 | 3/3/2002 | 1 | 100 | ||||||||
2 | 2/3/2002 | 2 | 200 | ||||||||
2 | 4/2/2002 | 3 | 1000 | ||||||||
3 | 10/10/2002 | 1 | 2000 | ||||||||
3 | 11/10/2002 | 2 | 100 | ||||||||
3 | 1/1012010 | 3 | 1000 | This would not be counted in current status as the selection is assumed 2003 | |||||||
Desired output format | |||||||||||
Dimension(Id) | Sum(Amount) | ||||||||||
1 | |||||||||||
3 | |||||||||||
2 | 2' won't appear because its CURRENT STATUS is '3' | ||||||||||
Thanks.
Hi İ have same problem with you could you find the solution
I hope that can be usefull.
But in your exemple Id 3 have a date in 2010... I did'nt understood why you bring it because it's the max date but it's not status = 2... Oo So I'm probably wrong.
Eva