This content has been marked as final. Show 2 replies
This question is related to my previous post:
I have two tables with the following (simplified) structure:
if(NOT Wildmatch(InvoiceCurrency,'EUR'), InvoiceCurrency&'-'&CutoffDate,'EUR') AS ComboCurrDate
So the tables are linked through the ComboCurrDate column.
I want to add a column for EurAmount so that I can use this field in set analysis and other scenarios.
Right now I use this statement to calculate the EurAmount outside my script:
if(NOT Wildmatch(InvoiceCurrency,'EUR'), (Amount / (1 * ECBrate)),Amount)
What do I need to do to create this calculated column? Create a third table, use a join - do I need a real key field?
I hope you can help me out here.