-
Re: Lookup, Sum and Textlist Cheat Sheet
@AlejandroGomez , You can use the ANY in the same way was SUM or Lookup, as well as FirstNonBlank and LastNonBlank. Honestly, I didn't know we could do this until David showed me: ANY: https://h…6 -
Re: Lookup, Sum and Textlist Cheat Sheet
@AlejandroGomez , Great explanation, but please do no use TEXTLIST() as this is a huge performance impact and goes directly against Planual Rule 2.02-11: TEXTLIST requires a lot of memory for calcula…6 -
Re: Subsidiary Views - Best Practices
@jk1nn1ck , The best resource we have right now is the Planual which is fantastic. You can find it here: link Regarding subsidiary views, they are not bad in that they perform poorly, but often times…6 -
Re: Difference between SUM function and LOOKUP function
@KOBAYASHI If your source has one unique member, it will be a lookup. If your source has multiple members, that will be a sum. Rob5 -
Re: Simple formula question for extra dimension
@jmiyagis Absolutely, no worries, please ask all the questions you have, this is exactly what the community is all about. Let's see if we can get you a solution. I have a module with two dimensi…5

