Forum Discussion

TimEgerton1's avatar
TimEgerton1
Qrew Member
4 years ago

Week on Week Sales Comparison using Formula Query

Hi, We have a sales summary table that has a sales total per week. [Week Ending], FID 6 and [Sales Total], FID7. We would like to do a week on week sales comparison using a Formula Query (if tha...
formula queries
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
4 years ago
Hey Tim,

I believe you are missing some key elements in your formula.

All GetRecords does is 'get the records' you still need to tell Quickbase what to do with them (Size, SumValues, or GetFieldValues).

SumValues(GetRecords($THISWEEK),7)-SumValues(GetRecords($LASTWEEK),7)

I suggest watching these videos to learn more about the exact syntax:


------------------------------
Quick Base Junkie
------------------------------