- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated field from multiple columns
I want to create an "Amount Converted" field from the following
I have one column with "amount" one with "Currency" and a table that contains the "conversion rate".
what script do i write that creates "Amount Converted" that calculates "amount" * "Conversion rate" based on "Currency" column?
New to scripting so any help i can get will be appreciated
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Solution found with the help of Deepak Kurup for giving me the answer and to Abhishek Agarrwal's video on how to do the syntax.
I joined the table that contained the values and the table that contained the currency rate. Now the two are linked with a full outer join and i can now create a calculated field of Amount Converted
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I guess the conversion rates are in another table ?
Could you please share an overview of the table with the rates ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello!
thanks for replying!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the above table has a column with "currency" which i'm using to link the two table's together
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Solution found with the help of Deepak Kurup for giving me the answer and to Abhishek Agarrwal's video on how to do the syntax.
I joined the table that contained the values and the table that contained the currency rate. Now the two are linked with a full outer join and i can now create a calculated field of Amount Converted