In SharePoint 2013 Foundation edition using SharePoint 2010 workflow engine, I've got a workflow which handles the companies onboarding/leavers/movers process and it submits tasks to various people around the company. I'm having an issue with it where it tries to increase the percentage complete of the master task but fails due to incorrect data type being updated. I understand this problem, but I can't see why it's a problem and how I could resolve it.
So for context, a 'percentage increase per subtask completion' is calculated. For this particular task, this value is calculated at 0.125 (shown as a percentage). Once the subtask is complete, it updates it from 0 to 0.125 successfully. However on the second subtask, it fails. The new value is 0.25.
I've also just tried it with a different value of 0.1429 per subtask completion and it's still failing.
Data types are listed below:
- Variable 'NewPercentage' - Number
- Column '% Complete' - Number
- Column 'Percentage Increase Per Subtask Completion' - Number
The workflow designer are returning all these values as the data type 'Double'.
I'm really struggling to find a resolution to this problem so any help is appreciated.