Nintex Workflow – Calculate Half the Size of a Collection UDA
Calculating the size of a Nintex Workflow collection variable is not hard to do. There is a Collection Operation action and it can be configured to do a Count on a collection variable and store the result in a Number variable. To get half of that number is also quite simple, in that there is a Math operation action that can divide that number by two. Sometimes though, the number of values in a collection is an odd number, and as a result of dividing it by two, you get a non whole number. eg. if the collection had 5 values, half of that is 2.5.
In this scenario, what have is a collection of approvers. What we need, is at least half of them are require to approve a task.
The Request Approval action has an Approval option named “Vote”. This is where you specify how many people need to vote for approval. It is basically a minimum approval count required.
User Defined Action
The above description of a calculation is fairly basic. In order to get a whole number, we need a few more actions.
- Collection Operation – this gets the total count of values in a Collection Variable
- Math Operation – divide the count by 2 (two)
- Build String – to use the Inline function fn-Round (this will round up/down the number)
- 4. Convert Value action – to convert the text string from Step 3 to a number variable.
Again, all this is quite basic. Why put it into a UDA? Well, it’s 4 actions I won’t have rebuild if I need to do this later.
The reason I want to stress that all these steps are easy, is that creating this UDA was about making something reusable, something that is easily shared and demoed.
To use this UDA, you simply pass in a Collection variable as input and a Number variable as output.
Once you have run this UDA, if your UDA has 5 values in it, you will get the number 2 back. You can then use this Number variable in a Request Approval action to get 2 approvals back from a total of 5 approvers… or 3 approvals back from 6 approvers etc.