CommunityMember115881 
-
Re: Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi, I can offer another solution, not the cleanest design but it seems to get the job done. What I did is to first move away from real time with a Fake Time list (using LOOKUP and a simple mapping ta…1 -
Re: Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi Rob, Yes I had seen the video, very interesting. However that wasn't my question. In this particular case the target is not dimensioned by time but Fake Quarters (Q1, Q2, Q3, Q4 so not linked…1 -
Re: Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi Chris, This was a good idea however I believe what the user is after here are averages by quarter (e.g. Q1 2020 and Q1 2021 for week 1) and not for all quarters at once like you are suggesting. Th…1 -
Re: Child with several parents in hierarchy
Hi Emmeline, I suppose it depends on the context and whether the children should be unique or can be assigned simultaneously to various Entities. In the below example I simply created a numbered list…1 -
Re: circular reference error with no time dimension used.
Hi Madhu, I have another solution to offer: simply map your custom list (which ever is applied to your line items 1-3) to real time periods. All your have to do, is create the logic against real time…2
