I am trying to produce a formula to calculating carbon emissions factors.
When inputting a new meter record I need the date to return a value if it is between two dates.
I then need that value to be multiplied by the new meter value.
For this to work I presume I am going to need to set up another table with all of the dates and values I want to be returned. But how do I lay the table out?
Do I do a start date and end date? Month on Month?
Really need some help on the formula and how to set up the new table.
Thank you in advance.
Tom shared this idea