Skip to Content
Former Member
Aug 29, 2007 at 10:09 PM

Formula help - Group totals for more than one date range


Post Author: melcaylor

CA Forum: Formula

I need to show in 3 columns

inside of a grouping that totals an amount field based on a date

range that amount was posted. So for example:

Billy Bob in the state of MA made $5.5m total, $800k in the last 21 days, $400k in the last 14 days and $150k in

the last 7 days.

I assume this is possible but I

just donu2019t know what type of formula to write to make it work. For this

example, there are 2 tables u2013 user table and $$ table. The User table has

the user name, the $$ table has the pay date and the amount.