10 Replies Latest reply on Dec 15, 2017 4:44 PM by user3507711

    Edit Formula issues in Answers

    user3507711

      Hi,

       

      I am using the below case statement in the Edit Column formula at the Analysis level of particular column and it is throwing the error as follows:

      [nQSError: 10058] A general error has occurred.

      [nQSError: 43113] Message returned from OBIS.

      [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)

       

      COUNT(DISTINCT CASE WHEN "DATE_Table"."DATE_Column"
      between
      CAST(TIMESTAMPADD(SQL_TSI_DAY,- DAYOFWEEK(@{PBofrom}{02-JAN-2017}) +2, @{PBofrom}{02-JAN-2017}) as DATE)
      AND
      CAST(TIMESTAMPADD(SQL_TSI_DAY, 8-DAYOFWEEK(MAX(@{PBoto}{17-DEC-2017})), MAX(@{PBoto}{17-DEC-2017})) as DATE) THEN "Incident"."Incident No" END)

       

      OBIEE Version: 11.1.1.7.1

      Can someone please let me know if this case statement is having any issue.

       

      Your help is highly appreciated.

       

       

      Thanks In Advance

      Siva