Skip to main content
Question

QUERY ERROR MESSAGE

  • February 27, 2024
  • 0 replies
  • 41 views
Forum|alt.badge.img+8

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • February 27, 2024

    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
    ------------------------------
    Terms & ConditionsAccessibility statement