4 Replies Latest reply on Dec 6, 2018 4:03 AM by Zhouyi Zhang Branched from an earlier discussion.

    Re: Expected ''END" to match 'IF' at character 0

    Sindhu Ayyadapu

      Hi,

       

      I have below query which is giving me an error " Expected ''END" to match 'IF' at character 0" can you tell me what is wrong in the query.

       

      IF  [Order Release Refnum Qual Gid] = 'GE/GE002.IS_HUB'

      AND ([Order Release Gid (Order Details)] = [Order Release Gid])

      case [Order Release Refnum Value] = 'NO'

      THEN (([Total Weight Base]) * 0.453592)

      ELSEIF [Order Release Refnum Qual Gid] = 'GE/GE002.IS_HUB'

      AND ([Order Release Gid (Order Details)] = [Order Release Gid])

      CASE [Order Release Refnum Value] = 'YES'

      WHEN [Order Release Refnum Qual Gid]='GE/GE002.SUB_RELEASE_TYPE'

      AND ([Order Release Gid] = [Order Release Gid (Order Details)]) and CONTAINS ('HUB-SHOP','CUST-HUB')

      THEN(([Total Weight Base]) * 0.453592)

      else 0

      END

       

      Thanks very much in advance!