SharePoint Designer 2013 Workflow: Do Calculation Action Example

This SharePoint designer workflow tutorial explains SharePoint designer 2013 do calculation workflow action. Learn how to use SharePoint designer workflow do calculation action in SharePoint Online/2013/2016.

If you are new to SharePoint designer 2013 workflows, then you can download and install SharePoint designer 2013 and you can create your first SharePoint designer 2013 workflow.

SharePoint designer workflow do calculation

The Do calculation SharePoint designer 2013 workflow action is used in SharePoint designer workflow to do an arithmetic operation on the list item. We can use do calculation SharePoint workflow when items belong to the same list. We can do addition, subtraction, multiplication, division and modular division mathematical operation on the list item.

Do calculation SharePoint designer workflow action Example

Lets take an example. I have a list named as Employee Salary. The Employee Salary list contains columns like:

  • Title
  • Annual Salary
  • Monthly salary
  • Output

We want to divide the employee Annual Salary with Monthly Salary and store the output in the list in another column. For this, we will use Do Calculation SharePoint designer 2013 Workflow action.

The SharePoint Online list looks like below:

sharepoint designer workflow do calculation
sharepoint designer workflow do calculation

Now, Open SharePoint designer 2013 and Open the SharePoint Online site. Click on Workflows and choose your list on which list you want to attach the workflow.

Here I have chosen the List name as Employee salary because I want to attach the workflow in “Employee salary” list like below screenshot.

sharepoint designer do calculation
sharepoint designer do calculation

After click on the list name one Create List Workflow page will come. The “Add a new workflow to your list” page will contain the below field

Name: Enter a name for the workflow, I have given the name as Workflow For Do Calculation.

Description: Enter a description for the SharePoint designer 2013 list workflow.

Platform Type: In the drop-down, we can see 2 option. SharePoint 2013 workflow and SharePoint 2010 workflow.

Choose SharePoint 2013 Workflow Platform type, Click on OK to create the workflow.

sharepoint designer 2013 do calculation
sharepoint designer 2013 do calculation

Now we can able to see stage one page. Below “start typing” we can able to see an orange line. Click on the orange line then we can see our condition, action enabled.

Then click on Action. In the Action, we can able to see Recent action. Click on Log to History List which is below the Recent Actions. Then log to history added to our designer page.

Log to History list is it is the entry to the History list. It is the start point from where the workflow will start.

sharepoint designer 2010 workflow do calculation
sharepoint designer 2010 workflow do calculation

After adding Log to History List we can able to see “message”. Click on message a box will come. Write some message Here I have written WorkflowInitiated.

After giving the message we will go for “Do Calculation Action“. For adding Do Calculation action in the designer page Click on “Action” Option.

do calculation sharepoint workflow
do calculation sharepoint workflow

We can see our Do Calculation action is added to our workflow designer page. Click on two value, the box will come then select the Column names of the list with which we want to do the mathematical operation.

Then Click on the operation. The operation is plus by default. To change the mathematical operation click on the plus to change the operation.

sharepoint designer workflow do calculation
sharepoint designer workflow do calculation

After the do calculation action added to our list if we want to see the calculated output in our list then add Update List item action to our designer workflow page.

sharepoint designer do calculation
sharepoint designer do calculation

Then in the Update List Item action, we can configure to store the calculation value to the Output list column.

sharepoint designer 2013 do calculation
sharepoint designer 2013 do calculation

Now you can publish the SharePoint workflow and add an item to the SharePoint Onlne list.

The SharePoint designer workflow will trigger and it will do the calculation and update the Output list column.

You may like following SharePoint designer 2013 workflow examples:

Conclusion

Here in this SharePoint designer workflow tutorial, I have shown you how to use do calculation SharePoint designer workflow in SharePoint Online or SharePoint 2013/2016/2010.

>