Skip to main content

Hi there, I am using the following formula to calculate total donations received within a period of time:



IF(


AND(


YEAR({Received Date}) = YEAR(TODAY())


),


{Amount}


)



However, I would like to modify this, so that instead of “TODAY()” - which gives the current year (2020) , I can set a time period like March 1, 2020 to February 28, 2021 (which matches our financial year).



How do I do this in existing formula?

Hi @BU-NPO,



Welcome to Airtable Community! :grinning_face_with_big_eyes:



I think your best option would be a view that shows you the dates that you are looking for.



Or are you looking to do some calculations based on the result?



BR,


Mo

Hi @BU-NPO,



Welcome to Airtable Community! :grinning_face_with_big_eyes:



I think your best option would be a view that shows you the dates that you are looking for.



Or are you looking to do some calculations based on the result?



BR,


Mo


Thanks



I need to calculate a result.



I am using Page designer to generate donor receipts, so I did use a new grid view with a filter that pulls in only the records from within the specified period (that works well) but I am unable to generate a total figure for the same range.



So I used a rollup (sum values) to calculate the total amount but it is adding up all the entries from the donor…I was trying the formula above in order to create a second rollup for only the amounts in the desired time period but I’m not sure how to specificy a range beyond “YEAR(TODAY())”

Thanks



I need to calculate a result.



I am using Page designer to generate donor receipts, so I did use a new grid view with a filter that pulls in only the records from within the specified period (that works well) but I am unable to generate a total figure for the same range.



So I used a rollup (sum values) to calculate the total amount but it is adding up all the entries from the donor…I was trying the formula above in order to create a second rollup for only the amounts in the desired time period but I’m not sure how to specificy a range beyond “YEAR(TODAY())”


Well now you can make a conditional rollup formula. So you choose the condition of the rollup to be the date between the dates you are looking for. It is better and easier than creating another formula in the same table.

Well now you can make a conditional rollup formula. So you choose the condition of the rollup to be the date between the dates you are looking for. It is better and easier than creating another formula in the same table.


Thanks so much. I am so new to Airtable I didn’t even see the button on the rollup to add conditions. Wow, that makes it really simple.



Thanks!

Reply


Terms & Conditions