About MarkTurkenburg

Thanks @rob_marshall  ... View more

@rob_marshall can you provide the Blueprint for your screenshot line items?   Much appreciated    Mark ... View more

Hi @rob_marshall    The Time Period is set to Month but why would the FY19 period return Jul18. This is the 1st period in the hierarchy and the SUMMARY is set to Formula, not FIRSTNONBLANK     Thanks ... View more

Thanks @jasonblinn  - I think your response would work in most situations   FYI for everyone: The reason for the sorting issue seems to be because the Line Item was a subsidiary view. I created a replica line item in another module with the same dimensionality & referenced the original data and was able to sort   ... View more

Thanks @anirudh  but this seems like overkill for what should be very simple piece of functionality. This would change the list order while I am merely wanting to sort values within a module     ... View more

Hi @ArunManickam    The Use Case is that I am required to enter commentary for variances to Budget for specific cells. I'm struggling to come up with a workable solution that doesn't involve sending the budget owner an excel file with the commentary, which is far from ideal   Mark  ... View more

Thanks @DavidSmith. I think the pertinent point there is 'don't over think it' 😂 As per usual I think I may of been getting too in the weeds but it's good to flush out the issue with the experts   Appreciate the assistance provided by yourself and everyone else on this thread   Mark ... View more

12k line items! @nathan_rudman  🤕   I was actually referring to how the model performs in general, e.g. how fast it is to move around, open modules etc rather than the initial opening          ... View more

Thanks @Misbah!   Funny but this session by @Griffink was exactly what I was referring to in my original post. I was in the audience for the session & remember being super impressed but it was also the 1st place I encountered the 'Waves' concept   I'll work through it 👍   Mark ... View more

Agreed with all of those @JaredDolich    I guess I'm trying to determine if all of those standard best practice items that you mention have the same impact of reducing calculation waves   I'm rambling too but just putting the thoughts out there 😁   Mark  ... View more

Thanks @JaredDolich    Yes it's an interesting one & I might be thinking too deeply about it but I remember during 2020 CPX there was a session on Best Practices & they spoke briefly about calculation waves and the effects on performance   I guess I am trying to increase my understanding of the Hyperblock/best practices to determine whether I should be materially focusing on Waves when building a model or if function/formula composition, avoiding text/using Booleans etc & dimensional consistency (referencing modules with the same dimensionality) is more impactful to performance   Thanks ... View more

Thanks @rob_marshall    Yes I can see that sometimes they may not be 100% ideal but it's not the end of the world to use them   Appreciate your help!   Mark ... View more

Nice @jasonblinn!   That's a pretty cool solution, I would not of thought of using a Subsidiary view to attain this result but I can see how it works   Thanks for the effort involved in creating this!   Mark ... View more

I think I'll have to but was whether it would cause any adverse consequences. I think there are 2 that can be mitigated:   1) Adds to module space but by turning off SUMMARY this can be reduced (not appropriate in all circumstances) 2) Incorrect formulas from a module without the dimension referencing a module with the dimension will return a value (SUMMARY). Previously an error would occur & this would help assist you in remembering you should not have a dimension mismatch when this List is included   Thanks!   Mark   ... View more

Thanks @jasonblinn  but I can't use the ANY function unfortunately, let me step out my issue a bit more clearly 😊     I have a module which is dimensionalised by 'Ramp-Up Month' which is the column dimension (1,2,3 etc). This dimension does not have a Top-Level as it is not required to be aggregated. The Line Item is an 'Override' Line Item & I need to produce a Filtered view of the module for any intersections whereby there is a value <> 0.    If I try to do a standard Filter straight out of the module I need to select which List items to use for the Filter & hence I cannot chose the Top Level for the Ramp-Up dimension   If I create a new SYS module without the Ramp-Up dimension I could use this for the Filter but I need to be able to return a TRUE for any intersection dimensions from the original module where ANY of the Ramp-Up items was <> 0. I can't use ANY here because I do not have the Ramp-Up list as a dimension     Thanks           ... View more

My bad I was reading the instructions incorrectly   It was just that simple!   Thanks     ... View more

    Hi @Harsha    Anapedia states the syntax is (cell containing text, text to find, starting point) which is what I did.    Is Anapedia incorrect?   Thanks       ... View more

Awesome - thanks @anikdas !   Mark ... View more

Good idea @jasonblinn - thanks! ... View more

Good idea @NakulAggarwal  in increasing the 2nd Column size rather than the 1st - nice simple solution ... View more

Hi @einas.ibrahim    I meant "down the bottom" of my screen shot - I had " " & was copying the space between the 2 quotes   But it doesn't work for me. I copy the character but when I paste there is no invisible character that is pasted ... View more