We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Expression invalid

Question
74
Views
0
Comments
edited Nov 20, 2014 7:58AM in Reporting and Analytics (TBE)

Content

Hi,

I am creating a new report using the "Requisitions by Owner" topic.  I am trying to add an expression to the report so that I can filter by status.  I have used this exact same expression on at least 2 other reports (it is exact because I am using copy/paste) and it works with no issue.

Now that I am creating the new report I am getting an expression invalid error.  Any ideas on why?  Could it have something to do with the topic?  That is the only difference in the reports.

This is the expression - if (IN([REQU|status] , "Open","On Hold")) "Open" else "Not Open"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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