5 Replies Latest reply: Jul 21, 2017 4:11 AM by Jose Miguel Vilaplana RSS

    how to write if else condition

    naveen kumar

      Hello All,

      I am merging both expression by using or function is that correct  ,what it mean  is either one scenario is right then show spend,but I thinking the way I am merging is not correct ,because I am getting -1 as output of all the materials



      Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column<>p_Material"}>}SPEND) or

      Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column=p_Material"} ,p_Material={"=count(distinct Ip_ID)=1"}>}SPEND)