AnsweredAssumed Answered

Help with calculations

Question asked by MikaGoodfriend on Apr 16, 2013
Latest reply on Apr 16, 2013 by MikaGoodfriend

Title

Help with calculations

Post

     Hello,

     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.

     Thanks.

     Mika

example.jpg

Outcomes