Help with calculations
I have been using Filemaker Pro for data entry to keep track of my expenses and income for my sole-proprietorship. I have no experience with scripts or calculations, however, I need to learn how to accomplish a currency conversion task.
I have a layout called 'Currencies' in which I have the yearly currency conversion (into Canadian dollars), along with the conversion rate.
In my main 'Expenses' layout, I list amounts, and the currency used, along with the date.
What I need is a calculation or script that will call on the correct conversion rate based on the currency and date I entered in 'Expenses', and apply it where needed in the 'Total' field. Is there anyone who can help me with this? I've tried to read up on calculations but it's completely over my head and this isn't the easiest calculation scenario.