How to Calculate a Daily Cost on Dashpivot Web

Video Walkthrough

Before you begin make sure you have the following:

Plan: All Plan Types
Permission:
- Home Folder (Template Library) – Org Controller (or higher);
- Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot

Open the Dashpivot template where you want to calculate a daily cost.
Identify the tables containing the cost components you want to include (for example, internal labour, external labour, plant, and materials).
In a formula field where you want to display the daily cost total, enter a SUM formula that references the relevant tables and columns.
For example, to sum all values in the A column from three tables, enter:
```
=SUM(Table1!A:A)+SUM(Table2!A:A)+SUM(Table3!A:A)
```
This adds the total from each table to calculate the overall daily cost.
Save the template to apply and use the daily cost calculation.