- BoostSolutions
-
Products
-
- Microsoft Teams
- HumanLike Alert Reminder
- View All Apps
- Pricing
- Support
- Company
BoostSolutions’ Calculate Boost Field enables you to do calculation based on other list columns easily.
In this example, there is a list in SharePoint with several columns to record the working hours and payment for part-time employee. We plan to create two Calculated Boost columns to calculate working hours based on log in and log out time, and the payment.
In this article, we will demonstrate how to do calculation in Calculated Boost Field in a SharePoint list.
Total Hours is a Calculated Boost column which shows the hours based on Log out and Log in time.Total Pay is a calculated boost column, it calculates the wage based on the working hours and wage rate.
There is a SharePoint list named as Part-time Employee Salary with following columns and items on a SharePoint site.
Download the trial version of Calculated Boost and install it to your SharePoint server.
Navigate to the Part-time Employee Salary list, click List tab. In the Manage Views group, click Create Column.
In the Name and Type section, enter a name in the Column Name field to give it a meaningful name such as Total Hours, then select Calculated Boost as the type of information in this column.
In the Additional Column Settings section, type this expression in the Formula box.
DiffHours([Log out],[Log in])
This expression will calculate the working hours based on log in and log out time.
Specify the data type from this formula as Number and specify the number of decimal places as 2.
Unselect the option of Do real-time calculation if formula contains [Today], [Now], [Me], User field, Lookup field etc.
Keep other settings as default and click OK to create column.
Navigate to Part-time Employee Salary list and you will find that a column named as Total Hours is created in the list as following.
In the Part-time Employee Salary, create another Calculated Boost column named as Total Pay.
In the Additional Column Settings section, type this expression in the Formula box.
DiffHours([Log out],[Log in])*15
This expression will calculate the wage based on the working hours and wage rate ($15-per-hour).
Specify the data type from this formula as Number and specify the number of decimal places as 2.
Unselect the option of Do real-time calculation if formula contains [Today], [Now], [Me], User field, Lookup field etc.
Keep other settings as default and click OK to create column.
Navigate to Part-time Employee Salary list and you will find that a column named as Total Pay is created in the list as following.
