Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing issue in currency conversion, please help me out to resolve the issue:
Table:
Id,name,month,currency
1,A,Jan-2021,Eur
1,A,Jan-2021,Usd
1,B,jan-2021,Eur
2,A,Feb-2021,Usd
2,B, Feb-2021,Eur
Table2:
Currency,Month,Rate
Eur,jan-2021,3.45
USD,jan-2021,1
Eur,feb-2021,3.25
USD, Feb-2021,1
Expected output:
Name,currency ,rate
A,Eur,3.45/3.25
A,USD,1/1
B,Eur,3.45/3.25
Id,rate
1,3.45/3.25+1/1
I need to show the above two output in two different table
Regards,
Nisha
can you elaborate more how do you do the calculations ? for example A,Eur,3.45/3.25 for A ?
If EUR exist in front of feb and jan ,then we have to divide Jan rate to Feb rate,for all Name,one name can have multiple currency,it may or may not exist in the next month.