Skip to content
More
Share
Explore
Perform calculation between two different tables
Example 1: See below →
DB Table 5 Example 1
Name
Expense
Hourly rate
Total expense
Currency symbol
Total expense view
1
Person 1
Expense 1
20
10
$
10$
2
Person 2
Expense 2
Expense 4
30
37.5
$
37.5$
3
Person 3
Expense 3
50
50
$
50$
There are no rows in this table
DB Hourly Freelance Expenses Example 1
Name
Length min.
Person
Currency
1
Expense 1
30
Person 1
USD
2
Expense 2
45
Person 2
USD
3
Expense 3
60
Person 3
USD
4
Expense 4
30
Person 2
USD
There are no rows in this table
DB Currencies Example 1
Name
Symbol
1
USD
$
2
EUR
€
3
GBP
£
There are no rows in this table
Example 2: See below →
DB Table 5 Example 2
Name
Expenses
Total expense
Base currency symbol
Total expense view
1
Person 1
Expense 1
Expense 3
72.5
$
72.5$
2
Person 2
Expense 2
22.5
$
22.5$
3
Person 3
Expense 4
72
$
72$
There are no rows in this table
DB Hourly Freelance Expenses Example 2
Name
Person
Length min.
Hourly rate
Currency
Exchange rate
Hourly rate converted
1
Expense 1
Person 1
30
20
USD
1
10
2
Expense 2
Person 2
45
30
USD
1
22.5
3
Expense 3
Person 1
60
50
EUR
1.25
62.5
4
Expense 4
Person 3
120
45
GBP
0.8
72
There are no rows in this table
DB Currencies Example 2
Name
Symbol
Base currency
1
USD
$
2
EUR
€
3
GBP
£
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.