Expand my Community achievements bar.

Using greater than on a daysdiff enrichment

Avatar

Level 2

hello, im struggling with what i thought was a simple enrichment / segment workflow.

 

I have a daysdiff formula within an enrichment, its generating the output into what looks like a number.

However, i have a segment as the next activity, where I am trying to check if that column is greater than 0 and am getting the below errors - 

 

PGS-220000 PostgreSQL error: ERROR: invalid reference to FROM-clause entry for table "r0" LINE 1: ...ecipient N2 JOIN wkf46377387_61_1 W3 ON (W3.iId = R0.iRecipi...

^ HINT: There is an entry for table "r0", but it cannot be referenced from this part of the query.

 

Any ideas if this is a formatting thing?

Help appreciated!

 

Screenshot 2022-10-02 at 16.45.27.png

Screenshot 2022-10-02 at 16.46.45.png

0 Replies