3 Year Average Transactions
Version: FM 10
Does anyone know how to create a field that calculates the average transaction amount over a three period? I'd like the field to calc not on a fixed date, but on three years since their last transaction.
Is it stupid to create a field to contain this data? Would it be better to create a sub-summary report in a new layout?
Thanks for your advice,