QUERY ERROR MESSAGE
If([Project Type]="Extended", SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}",[_DBID_RESETS]),28), SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}AND{144.IR.'this mon'}),[_DBID_RESETS]),28)
The pe...
Forum Discussion
You're closing out the second GetRecord too early with a ) directly after your query before you're telling it what DBID to target. Its resulting in your IF syntax being off also. Try:
If([Project Type]="Extended",
SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}",[_DBID_RESETS]),28),
SumValues(GetRecords("{186.EX.'"&[ResetID]&"'}AND{144.IR.'this mon'}",[_DBID_RESETS]),28))
------------------------------
Chayce Duncan
------------------------------