Calculated Columns.Example - 2
| Id |
Customer |
Amount |
Currency |
Payment Date |
Amount (in USD) |
|
1
|
Brown
|
1,250.00
|
EUR
|
2015-10-12
|
$1,421.42
|
|
2
|
Madson
|
2,325.00
|
CAD
|
2015-10-20
|
$1,787.91
|
|
3
|
Goodridge
|
780.00
|
GBP
|
2015-11-02
|
$1,204.45
|
|
4
|
Goodridge
|
450.00
|
GBP
|
2015-11-16
|
$684.41
|
|
5
|
Kerber
|
450.00
|
CHF
|
2015-11-26
|
$439.88
|
|
6
|
Jones
|
850.00
|
AUD
|
2015-11-30
|
$612.52
|
|
7
|
Jones
|
490.00
|
AUD
|
2015-12-07
|
$358.00
|
|
8
|
Goodridge
|
300.00
|
USD
|
2015-12-10
|
$300.00
|
|
9
|
Smith
|
700.00
|
CHF
|
2015-12-25
|
$709.72
|
|
10
|
Brown
|
450.00
|
USD
|
2015-12-30
|
$450.00
|
|
11
|
Davis
|
485.00
|
EUR
|
2016-01-10
|
$530.17
|
|
12
|
Madson
|
530.00
|
CAD
|
2016-01-12
|
$372.30
|
|
13
|
Smith
|
450.00
|
USD
|
2016-01-15
|
$450.00
|
|
14
|
Jones
|
1,120.00
|
AUD
|
2016-01-26
|
$780.76
|
|
15
|
Moore
|
350.00
|
GBP
|
2016-01-29
|
$501.00
|
|
16
|
Jones
|
350.00
|
AUD
|
2016-01-29
|
$248.23
|
|
18
|
Goodridge
|
120.00
|
EUR
|
2016-02-02
|
$130.90
|
|
22
|
Smith
|
150.00
|
USD
|
2016-02-04
|
$150.00
|
|
24
|
Goodridge
|
120.00
|
AUD
|
2016-02-08
|
$85.07
|
|
26
|
Smith
|
800.00
|
CAD
|
2016-02-10
|
$575.71
|
|
27
|
Davis
|
650.00
|
CHF
|
2016-02-12
|
$666.87
|
|
30
|
Jones
|
1,200.00
|
AUD
|
2016-02-16
|
$857.08
|
|
31
|
Taylor
|
450.00
|
USD
|
2016-02-17
|
$450.00
|
|
35
|
Moore
|
600.00
|
CHF
|
2016-02-19
|
$604.96
|