Collect () function with multiple/varying formats
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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!