479361_en-US

liliconcom

counting total item in each cell that contain different pattern

Hi,
I want to get the total count of the item in the cell under setting columns. Can someone give me suggestion how I can code it so it will take the value under :setting column and count the total number like what shown under :Total Items. Many Thanks.

 

Consumer and Market ResearchMass CustomizationRe: counting total item in each cell that contain different pattern

Here is the formula for the column Total Items, that I came up with.

count = 0;
i = 1;
While( Word( i, :setting, "," ) != "",
 theWord = Word( i, :setting, "," );
 If( Contains( theWord, "-" ) | Contains( theWord, ":" ),
  Show( Row(), theWord );
  count = ((count + Num( Word( 2, theWord, "-:" ) )) - Num( Word( 1, theWord, "-:" ) )) + 1;
 ,
  count
  ++);
 i++;
);
count;