Jump to content

Case Inside a Case


Alec
 Share

Recommended Posts

Hi, I am using the following script but I am getting errorWould you please help me figuring out what's wrong Case WHEN C.#COTYP = 'LA' THEN CASE WHEN C.#COFBD = H.#SOEDT THEN (I.#SISLS * C.#CONPY) ELSE 0 END WHEN C.#COTYP = 'LZ' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'LS' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MA' THEN (I.#SISLS * C.#CONPY) // WHEN C.#COTYP = 'MD' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MM' THEN (I.#SISLS * C.#CONPY)// WHEN C.#COTYP = 'MP' THEN (I.#SISLS * C.#CONPY)Else I.#SISLSEND AS SALESPRICE, Thxs

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...