Forum Discussion
Getting a row level operation by using two different tables
Hi Folks,
I have 2 tables like
| Loan | |||
| Party name | currency | date | org_amount |
| john | usd | 15th jan | 30 |
| joy | usd | 16th jan | 40 |
| chandler | aud | 20th jan | 20 |
| monika | eur | 14th feb | 40 |
| phoebe | din | 20th feb | 20 |
another table having
| Currency History | ||
| Date | currency | conversion amount |
| 20th jan | usd | 81 |
| 20th jan | aud | 84 |
| 20th jan | din | 82 |
| 20th jan | eur | 84 |
| 21st jan | usd | 87 |
| 21st jan | aud | 83 |
| 21st jan | din | 81 |
| 21st jan | eur | 84 |
| 22nd jan | usd | 92 |
| 22nd jan | aud | 85 |
| 22nd jan | din | 82 |
| 22nd jan | eur | 84 |
I wanted to give a date slicer as an input date from the rate history table i.e. 2nd table and want to calcualte the amount by multiplying the org_amount * conversion rate for each party. I have tried joining both the tables but i am getting huge number of rows.
whated to get an output like this. based on user input date
| Loan | ||||
| Party name | currency | date | org_amount | org_amount * conversion amount |
Thanks
7 Replies
the calculation should be base on the currency = currenct and date = date ?
Hi Daniel29195 ,Date is from 2nd table because the values are varying and we need to chhose a date,depending upon input date it will pick up the values from the 2nd table and multiply the origional amount
tried with solutions but unable to take 2 different columns from 2 different tables
