Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
9 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 period after the IR. statement I am receiving "Please check the syntax of your formula. Look for....

I cannot figure out what I am missing here.



------------------------------
Hans Hamm
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    9 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
    ------------------------------