ERROR: column "=" does not exist Position: 273

Sarah_McRae · January 15, 2023, 9:01pm

I tried using the "SumIf" operator to make a Custom Expression and I received the error "ERROR: column "=" does not exist Position: 273".

TonyC · January 16, 2023, 9:19am

Can you share the Custom Expression and an image of the GUI editor so I can see what you are aggregating

Sarah_McRae · January 16, 2023, 1:56pm

Thank you for responding to my question, @TonyC .

The Custom Expression is:
SumIf([Is Entrepreneur] = True, between([Core User - User → Created], "2022-01-01", "2022-12-31"))

I'm also attaching an image of the GUI editor.

TonyC · January 16, 2023, 3:29pm

If you check the Documentation you will see you have some wrong setup for the SumIf:

So in your case you will need to:

SumIf([some_column_you_need_to_sum], [Is Entrepreneur] = True AND between([Core User - User → Created], "2022-01-01", "2022-12-31"))

Sarah_McRae · January 17, 2023, 1:10am

Thank you, @TonyC ! That clears this up!