Issue in currency rate

[nisha_rai]

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

[Taoufiq_Zarra]

@nisha_rai 

can you elaborate more how do you do the calculations ? for example A,Eur,3.45/3.25 for A ?

[nisha_rai]

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.