Hi Nikhil ,
As per your criteria x,y or z should be displayed only when it matches Production,Pipeline or Development
CONTAINS([Type B],"Production") then "x"
ELSEIF CONTAINS([Type B], "Pipeline") then "y"
ELSEIF CONTAINS([Type B],"Development") then "z"
May be you can introduce a 4th type which does not matches any of the above as
no, that's not what I want
I want 3 columns - x, y,z
and if a particular calculation has no values then it should show that value as 0
column x will have 0 in above case