6 Replies Latest reply on Jul 16, 2018 6:07 AM by Vijay Srikanth GVL

    Multiple Case Statements

    Vijay Srikanth GVL

      Hello all,

       

      I am facing a small issue in getting a case statement correct. As shown below i am looking for three conditions to match Reporting Date, Opty_Number and Close Quarter where i should get the Sum(Current Values_WoW) at an Opty_Number level but i am not getting any value.

       

      However if i am using a Single case when statement (2nd statement in the below image) as below i am getting a result but missing on other two parameters i.e., Compared to Date & Close Quarter.

       

       

      Would be great if you can help me.

       

      Thanks in advance.

       

      Regards,

      Vijay