-
1. Re: 'Simple' Lod inside a Lod
Jim DehnerApr 13, 2018 6:22 AM (in response to timothy rafferty)
Good morning
is this what you needed
i used this to determine the min date by contractor/project
then this for date difference
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
lag_v10.2.twbx 32.8 KB
-
-
2. Re: 'Simple' Lod inside a Lod
timothy rafferty Apr 13, 2018 6:29 AM (in response to Jim Dehner)Ah.. thanks.. that's it
I always forget that trick of 'nesting' the dimensions in the Fixed statement.... Fixed[Project,Contractor]
-
3. Re: 'Simple' Lod inside a Lod
Jim DehnerApr 13, 2018 6:34 AM (in response to timothy rafferty)
Your welcome
It is easy to thing of an LOD as an aggregate but actually it is not - it creates another level that can be further aggregated -
so you can think of it like moving all the potential calculations - date, conditional, another LOD or table calculations - to a higher level (aggregated) in the data structure
Glad to help out
Jim