Hello,I am working on a property management system and there are contracts in two currencies. For all the data to make sense I need to convert the dllr contracts information to pesos with the current exchange rate. In the table where I have inflation...
Trying to do an airtable base for tracking lease contracts information. On one table I have the contracts data: Client, date of lease, term, area, price etc.On another table I have inflation data. (Either CPI or INPC), Monthly data.What I would like ...
I am thinking that if this is not possible since anyway I need to monthly update the inflation data I can have the calculation made in excel and jut copy all the calculated column with the acumulated inflation up to date and copy all the data to Airt...
My problem is that in Excel I would not be able to have all the powerful features of grouping, filtering and having all the related information. Maybe I can try to do an automation to get just the inflation table with the results I need from Google S...
Thank you Scott. I saw the video and for me it's more complicated than I thought. Can you explain how can I define a column in this same inflation table where I divide each row by its latest row. I know it's kind of the same question but isn't it pos...
