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

Logical Functions

edited Jul 17, 2017 3:51PM in Reporting & Analytics for B2C Service 4 comments

Content

Hello all - I tried to perform a search to see if I can find anything that may help and i've tried a few options and haven't had any luck.

I'm trying to create a logical function to pull a Y/N based on if the note actually exists for that line item.  

Example: I'm pulling from NTS$Notes.notes_type and if the notes type equals X then i'd like it to return a Y/N.  

I tried to create the logical function: if(NTS$Notes.notes_type=9,"Yes","No") but it doesn't work.  The #9 refers to the note type ID for clarification.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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