Using greater than on a daysdiff enrichment
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!
