CommunityMember115881 
-
Re: How to FINDITEM without CODE
Feel free to post here your design if you can't work it out. I'll take a look1 -
Re: Alternative to LOOKUP with non-composite hierarchies
Thanks Amaya for the explanation. So I've managed to solve it using Time for sequential calculation. Warning, it aint pretty but it does work. The idea is simply to SUM then LOOKUP using one lis…1 -
Re: circular reference error with no time dimension used.
Hi Madhu, Without having a proper look at it it's a bit hard to tell. In theory it should work just fine. I wonder if it doesn't have something to do with your formula for "Interest ac…1 -
Re: Convert Text to Number following comma format
Hi Tom, Here is one way to do it. Only limitation: you'd have to create additional loops for numbers higher then 999 billions I hope this helps. Regards1 -
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
