Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
5 years ago

Formula to get a value of a field from a record that is one month older than another record

I have a table in our CRM that keeps track of what clients are spending. Every day a copy of all of the client information including the spend is saved to that table (copies all field values from `Cli...
Formulas and functions
Relationships
DougHines's avatar
DougHines
Qrew Trainee
5 years ago
Could you possibly utilize a summary field  in the Client Snapshot table? Set the summary to get the total value of spending (assuming you have that in a field somewhere), where the creation date of the snapshot is 30 days in the past.  Then you could add a report formula field to calculate the difference between this newly added field with the snapshot data already in the system.


------------------------------
Douglas | dhines@tritonnet.com
|
Service Delivery Coordinator | Tier II Support | Systems
------------------------------