Forum Discussion

a4's avatar
a4
Icon for Helper III rankHelper III
6 years ago

How to perform calculation on fields from two different table which don't have any relationship

Hi

I have two tables(quotedetails, spl_fixedratepremiumhistories).I want to multiply priceperunit(Quotedetails) to spl_baserate(spl_fixedratepremiumhistories). I have a Iso currency code field in common in both the tables. Conserding this field as a basis how can I multiply both the fields.

 

Please find the below screenshot attatched for better understanding

 

Any help is appreciated

 

Regards

Amit Kumar

 

Need Help

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

     Hi a4 , 

    If possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • a4's avatar
      a4
      Icon for Helper III rankHelper III
      6 years ago

      Hi

      Please find attatched below the screenshot for better understanding.

       

      I want to multiply _baserate(_fixedratepremiumhistories) with priceperunit(quotedetails) depending on Iso currency code from both table. There is no direct relationship between these two table. These two tables are in relation with the third table transcationcurrencies. Please find the screnshot for better understanding.

       

      Please suggest any possible solution.

       

      Kind Regards

      Amit Kumar