Comments

  • 1-6 of 6
  • Dawn Phipps

    I am getting an error.... tried to click ignore but that did not work.

    Formula syntax is invalid.
    [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .Please have your System Administrator look at the log for more details on this error. (HY000)
    Please have your System Administrator look at the log for more details on this error.
    Please have your System Administrator look at the log for more details on this error.
    OK (Ignore Error)

  • Dawn Phipps

    Hi Rachel,  I had a question about concatenating a field that contains more than one value?    So if I don't do any concatenate it puts each value (when there are 2) on separate lines in the report.   If i do  Max(Field A) || Min(Field A)  then when there is 2 values in the field it works fine.  Both values show on one line in the report.   But when there is only one value in the field then MAX and MIN are the same and it just duplicates the only value in the same field.    

    Value 1 || Value 2   - OK

     Value 1 || Value 1  - Not OK

     

    My data looks kind of like this.....so I want to use concatenate some way shape or form...

    ------------------------------------------------------------------------

    Value 1     John Doe

    ----------------------------------------------------------------------

    Value 2     John Doe

    ---------------------------------------------------------------------------

    Value 1     Jane Doe

    ----------------------------------------------------------------------------------

    MAX("Application Tracking - All Events"."Application Tracking Reject/Decline Motives")  ||' --- '||  MIN("Application Tracking - All Events"."Application Tracking Reject/Decline Motives")

    I want it to show me when there are 2 values to put them together in one line on the report and when there is only 1 value to put that value as it's own line on the report.  Am I making sense?  I don't know how to explain that.   I think i need to use some kind of sequencing or an evaluate to get the values?

    Your help is appreciated.

    -Dawn

  • Dawn Phipps

    I have no idea if this is the fix or not.  I have not had a reply to my post or comment.  Still waiting.  If you find out this does indeed work, please let me know.

  • Dawn Phipps

    Is this it?

  • Dawn Phipps

    I bet this needs to go to the ideas for voting.  But not 100% sure.  Great to know how to do this...

  • Dawn Phipps

    I tried timestampdiff but not with that exact syntax you have here Rachel.  This worked!!! Thank you so much!!!  I am going to save this syntax as many of our reports in BO have AGING columns in them so I am going to need this!  Much appreciated..yeswink