Hi All, I have 2 tables loaded using Load Editor. 1. Data with Currency and Amount (Table 1) 2. FX Rate table for every Day. (Table 2) Basically i am trying to get exchange rate for the date in Variable Input and all the amount from Table 1 should be converted using exchange rate from Table 2 using Variable input Date. I have solution having this date scripted in editor but i do not want to do this as this will not show quick result unless script is loaded again whenever there is date Change in Variable input. So i Would like to do this either in "Master Item" or in using Expression in Dimension. Or if there is another way to do . So that i can see Quick change in the calculation whenever there is change in date using Variable input.
What is the common key between Table 1 and Table 2?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
"From Currency" is Common in Both the Tables and I need the currency rate for Date (Provided through Variable Input ) which is available only in Currency Table. I can bring i Variable input into script but i am not doing it as i would like ot see the change or calculation immediately.
