Forum Discussion

sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper I
2 years ago

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 4...
Need Help
sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper I
2 years ago

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

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

sahubibhuti45 

ok. 

but if let us say you choose 20 of january, 

then all the data of the table Loan, should be multipled by the conversion amount of 20 of jan , respecting the currencies. 

 

is that right ?