Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
3 months ago

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...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
3 months ago

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
------------------------------