16.04 Understanding Formula Columns
UNItekTIME allows 5 formula fields in every report data source. A user can enter their own custom formula for these columns. And they can perform other reports functions like grouping, calculations (sum etc) and show in reports.

A typical case for Formula Columns:
Billing departments want to submit client billing reports with 10% extra overhead charges. UNItekTIME administrator then decided to [customize] [Task Billing By Projects/Clients] in [Billing Reports] category.
Report before customization:
Here are the steps required to be followed for customizing
[Task Billing By Projects/Client] report:
- Click on [My Reports] to launch [My Reports] page.
- Click on [Customize] link of report [Task Billing By Projects/Clients] in [Billing Reports] category.

- Click on [Next] in [Report Definition Information] wizard step.
- In [Report Data Selection] wizard step: follow these steps to customize [Task Billing By Project/Clients] reports to achieve above-mentioned requirements.

- Check on [FormulaField1] and update its caption to [Overhead Charges].
- Select [Sum] in [Show Summary] dropdown of [FormulaField1].
- Enter formula for calculating 10% of Amount: Amount * 10 / 100.
- Check on [FormulaField2] and update its caption to [Net Billing Amount].
- Select [Sum] in [Show Summary] dropdown of [FormulaField2].
- Enter formula for sum of original amount field and calculated [Overhead Charges]: Amount + FormulaField1.
- Click on [Next] to update these changes.
- Click on [Finish] button in final wizard step [Column and Group order].
- Now a new report will be created with name [Task Billing By Projects/Clients Customized]

- Clicking on this report in [My Reports] will show UNItekTIME customized report with two additional column [Overhead charges] and [Net billing Amount]

- Click on [Permissions] link to give this customized reports to your required Roles.
Article ID: 79, Created: 3/24/2021 at 1:10 AM, Modified: 3/24/2021 at 3:34 AM