I have this table: I am looking to build a formula that will look back 2 months, gather the sum of revenue for that month, and multiply it by 12 to get my Projected Sum. So hypothetically...
Do you have a calendar table that relates with revenue date?
Anonymous
Not applicable
8 years ago
MFelix I have a Date table but I don't have a relationship setup with it. Typically when I build formulas I just reference my date table in the formula if needed:
