The Collect() function is great for collecting values, however; becomes problematic when trying to bring in a combination of numbers and percentages, and impossible when trying to bring in text or list items.
It would be great if the collect formula could follow the same formatting as the source module (i.e. no need to set a formatting for the collect() line item as it will just bring in whatever the formatting is in the source module for the line item in the line item subset). I realise this would mean varying formats within a single line item (which Anaplan cannot currently do), but this would certainly remove a pain point I've come across many times.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.