You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can't filter by text in disp_id

edited May 30, 2019 1:40PM in Reporting & Analytics for B2C Service 4 comments

Summary

using instr on disp_id and can't filter on the result

Content

I have a variable in a report which has the following code

if(incidents.status_type=2, if(instr(incidents.disp_id,'cancel')>0,'Cancelled',if(instr(incidents.disp_id,'donation')>0 | instr(incidents.disp_id,'saved')>0 | instr(incidents.disp_id,'Direct Debit')>0,'Saved','Other')),'Open')

I want to filter a report that uses this variable so that only those where this variable is "Other" are returned. But I get the attached error.

I've tried with both the variable "$nomoniesstatus" as the filter, and the raw code, and neither work.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!