From the course: Blue Prism: Excel Automation

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculate GL account balance

Calculate GL account balance - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Calculate GL account balance

“

Within this loop, we'll need to create another loop, which will be going through the GL accounts data. In calculating the total balance for this particular GL account. And also, saving it into another collection which we'll later use to enter to the summary tab. Now create a new loop, which will be within the GL account loop. Make sure you move the stages around in order to fit the loop stage. Double click on it and call it GL Accounts Data. From the collection drop down, select the GL account data and click okay. The only stage needed in this loop is a calculation stage. So click on the calculation stage and place it between the start and the end of the loop. Double click on it and call it Calculate Balance. Before we start with building the expression, we will need to create a data item from type number. Which we will be using for incrementing the amount taken from the GL account data. In…

Contents