5 Replies Latest reply: Aug 7, 2014 7:48 AM by Sheldon Braid RSS

    Match Function with array of values

    Sheldon Braid

      Trying to use the Match Function against an array of values. I have an array of time values in Field "HourArray". Next I wrote a calculated dimension using the Match Function. and named it "Working Y/N" in the pivot table. My intent is for the Match Function to find the match for the single digit hour in field "HourOfDay" in the array stored in field "HourArray" , and have the result returned as Working or Not Working in field "Working Y/N". The match always returns 0. I have tried removing the single quotes in the array to no avail. If anyone has some insight to this, it would be greatly appreciated.

      Thanks All.

       

      Array.tif