topic Hi Jochem - you have 2 in Product Forum https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76217#M28748 Hi Jochem - you have 2 options.1) loop through the collection row by row. Although this may appear slow in Process Studio, don't forget that this will execute very fast in Control Room. Switching logging off will also make the loop run quicker.Create a new code stage, similar to those in the collections utility object. For this option I would recommend creating a new utility object and leaving the original untouched. Wed, 31 Aug 2016 13:28:00 GMT John__Carter 2016-08-31T13:28:00Z Use collection data all at once in calculation https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76216#M28747 Hi, I have a collection with 120 values. In mij calculation I have the next expression: Replace([Data.companies]; [Business.entity]; "") So, I want to check if there are company names with a business entity included and then remove the entity from te name. Currently I succeeded to do it one by one, but I need to do it all at once (check all entities in one run). How can I do this? Wed, 31 Aug 2016 13:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76216#M28747 JoachimGeelen 2016-08-31T13:17:00Z Hi Jochem - you have 2 https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76217#M28748 Hi Jochem - you have 2 options.1) loop through the collection row by row. Although this may appear slow in Process Studio, don't forget that this will execute very fast in Control Room. Switching logging off will also make the loop run quicker.Create a new code stage, similar to those in the collections utility object. For this option I would recommend creating a new utility object and leaving the original untouched. Wed, 31 Aug 2016 13:28:00 GMT https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76217#M28748 John__Carter 2016-08-31T13:28:00Z Thanks John, I used the first https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76218#M28749 Thanks John, I used the first option and indeed, it doesn't cost anytime running from the control room. Thanks! Thu, 01 Sep 2016 17:53:00 GMT https://community.blueprism.com/t5/Product-Forum/Use-collection-data-all-at-once-in-calculation/m-p/76218#M28749 JoachimGeelen 2016-09-01T17:53:00Z