Spreadsheet: 840708d1692908095-converting-currency-sample
Sheet: Sheet1

 | This is a pivot in main file |  |  |  |  |  |  |  |  |  | I need to convert the amount in USD based on column X,Y,Z
 | [NAME] | Invoice Number | Currency | 90 days + Overdue | 61-90 days + Overdue | 31-60 days + Overdue | 0-30 days + Overdue | Current, Not Due | Grand Total |  | [NAME] | Invoice Number | Currency | 90 days + Overdue | 61-90 days + Overdue | 31-60 days + Overdue | 0-30 days + Overdue | Current, Not Due | Grand Total |  |  |  | SN | Base  Currency | [NAME] to USD
 | ABC | 613 | EUR |  |  | 4462.52 |  |  | 4462.52 |  | ABC | 613 | USD |  |  | 4462.52 |  |  | 4462.52 |  |  |  | 1 | INR | 0.012
 |  | 614 | EUR |  |  | 4080 |  |  | 4080 |  |  | 614 | USD |  |  | 4080 |  |  | 4080 |  |  |  | 2 | USD | 1
 |  | 615 | EUR |  |  | 1425 |  |  | 1425 |  |  | 615 | USD |  |  | 1425 |  |  | 1425 |  |  |  | 3 | GBP | 1.22
 |  | 619 | EUR |  |  | 1000 |  |  | 1000 |  |  | 619 | USD |  |  | 1000 |  |  | 1000 |  |  |  | 4 | EUR | 1.05
 |  | 620 | USD |  |  | 5507.5 |  |  | 5507.5 |  |  | 620 | USD |  |  | 5507.5 |  |  | 5507.5 |  |  |  | 5 | [NAME] | 0.0073
 |  | 621 | EUR |  |  | 8035 |  |  | 8035 |  |  | 621 | USD |  |  | 8035 |  |  | 8035 |  |  |  | 6 | CAD | 0.73
 |  | 634 | EUR |  |  |  | 5600 |  | 5600 |  |  | 634 | USD |  |  |  | 5600 |  | 5600 |  |  |  | 7 | SAR | 0.27
 |  | 635 | EUR |  |  |  | 5100 |  | 5100 |  |  | 635 | USD |  |  |  | 5100 |  | 5100 |  |  |  | 8 | KRW | 0.00076
 |  | 636 | EUR |  |  |  | 4656 |  | 4656 |  |  | 636 | USD |  |  |  | 4656 |  | 4656
 |  | 637 | EUR |  |  |  | 477 |  | 477 |  |  | 637 | USD |  |  |  | 477 |  | 477
 |  | 638 | USD |  |  |  | 1075 |  | 1075 |  |  | 638 | USD |  |  |  | 1075 |  | 1075
 |  | 642 | EUR |  |  |  | 4000 |  | 4000 |  |  | 642 | USD |  |  |  | 4000 |  | 4000
 |  | 643 | EUR |  |  |  | 1982 |  | 1982 |  |  | 643 | USD |  |  |  | 1982 |  | 1982
 |  | 644 | EUR |  |  |  | 2800 |  | 2800 |  |  | 644 | USD |  |  |  | 2800 |  | 2800
 |  | 673 | GBP |  |  |  |  | 296.82 | 296.82 |  |  | 673 | USD |  |  |  |  | 296.82 | 296.82
 |  | 674 | EUR |  |  |  |  | 5100 | 5100 |  |  | 674 | USD |  |  |  |  | 5100 | 5100
 |  | 675 | EUR |  |  |  |  | 3309.02 | 3309.02 |  |  | 675 | USD |  |  |  |  | 3309.02 | 3309.02
 |  | 676 | EUR |  |  |  |  | 4000 | 4000 |  |  | 676 | USD |  |  |  |  | 4000 | 4000
 |  | 677 | EUR |  |  |  |  | 4000 | 4000 |  |  | 677 | USD |  |  |  |  | 4000 | 4000
 |  | 690 | EUR |  |  |  |  | 1034 | 1034 |  |  | 690 | USD |  |  |  |  | 1034 | 1034
 |  | 692 | EUR |  |  |  |  | 7500 | 7500 |  |  | 692 | USD |  |  |  |  | 7500 | 7500
 |  | 693 | EUR |  |  |  |  | 4000 | 4000 |  |  | 693 | USD |  |  |  |  | 4000 | 4000
 |  | 694 | EUR |  |  |  |  | 3200 | 3200 |  |  | 694 | USD |  |  |  |  | 3200 | 3200
 |  | 695 | EUR |  |  |  |  | 5100 | 5100 |  |  | 695 | USD |  |  |  |  | 5100 | 5100
 |  | 696 | EUR |  |  |  |  | 3200 | 3200 |  |  | 696 | USD |  |  |  |  | 3200 | 3200
 |  | 697 | EUR |  |  |  |  | 1398 | 1398 |  |  | 697 | USD |  |  |  |  | 1398 | 1398
 |  | 698 | USD |  |  |  |  | 1217.18 | 1217.18 |  |  | 698 | USD |  |  |  |  | 1217.18 | 1217.18
 | ABC Total |  |  |  |  |  |  |  |  |  | ABC Total