rob_marshall 
-
Re: Concatenate multiple items
@cmast Correct, you want to do the least amount of concatenations as you can as that is a massive performance hog. In your first example, there are 12 concatenations: T1 & "_" & T2 …1 -
Re: Better performance Win - Break up to reference calcs from system
@sychtysz18 Yeah, feel free to ask me about the exam in a DM as I wrote the vast majority of it. Not sure how the exam got brought into this as the OP was just asking about text performance, but to a…1 -
Re: Better performance Win - Break up to reference calcs from system
@seymatas1 It really is hard work with these hypotheticals, but generally TEXT is evil and can cause performance issues. Additionally, having deep IF THE ELSE statements can be problematic as well, n…2 -
Re: Keeping the length of the record constant
@RaghuMulki Give this a try: right("00000000"&line item,10)2 -
Re: Rank Cell Limit Clarification
@cmast Yes, the cell count of the line item containing the Rank formula has to be less than 50M cells. And yes, both rules are the same, but honestly, your list shouldn't be 50M members if you d…1
