Hi,
I have a module with 2 lists: currency (Local and GBP) and list item e.g. Expense. I input data into Local and Expense cell e.g. 1000. I want to calculate GBP amount of that 1000, by multiplying number in Local cell with FX rate. How do I write formula for the GBP cell? I find that I can only write formula for the Line Item.


Thanks
Andre