-
1. Re: Level of Detail Help
Deepak RaiJan 24, 2019 11:06 AM (in response to Stephen Lanham)
how is 565629 moved out?
-
2. Re: Level of Detail Help
Stephen Lanham Jan 24, 2019 11:11 AM (in response to Deepak Rai)This person was moved out and then back in (by error) and then back out again. her actual last record looks like this:
565629 01/10/19 12/31/2199 out 15903
I had filtered out all the records with the date of 12/31/2199, that counts as the current record, but for that person, I would like to show they moved out in Dec instead of Jan.
makes sense?
-
3. Re: Level of Detail Help
Stephen Lanham Jan 24, 2019 11:15 AM (in response to Deepak Rai)Here is the data with the 12/31/2199 rows in it, if it helps.
-
Book1.xlsx 9.8 KB
-
-
4. Re: Level of Detail Help
Deepak RaiJan 24, 2019 11:16 AM (in response to Stephen Lanham)
Then you need to change your logic.
-
5. Re: Level of Detail Help
Deepak RaiJan 24, 2019 11:20 AM (in response to Stephen Lanham)
You changed it for 298007 also, so here it is:
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to close Thread
-
Book3.twbx 77.2 KB
-
-
6. Re: Level of Detail Help
Stephen Lanham Jan 24, 2019 11:20 AM (in response to Deepak Rai)Ok, well, let's take out the condition of showing in Dec and go with the logic to show the movement, I can explain one-offs. Are you able to help me get started?
-
7. Re: Level of Detail Help
Deepak RaiJan 24, 2019 11:21 AM (in response to Stephen Lanham)
1 of 1 people found this helpfulplease check above.