AnsweredAssumed Answered

3 Year Average Transactions

Question asked by DanielKarp on Apr 10, 2011
Latest reply on Apr 11, 2011 by philmodjunk


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,