keeping your cases

[Kristyn Walters]

Is there a way to keep my special cases I typed in while also adding more through setting up formulas?  right now, all my cases seemed to get wiped out when I add cases.  thanks!

[Bill Finzer]

Hi Kristyn,

I can think of one way, but not sure if it will do what you want.

1. Suppose you have an attribute A and you have typed values into the first four cases.
2. Create an attribute B with the formula: if(caseIndex<5,A,random()). This copies the entered values from A into B and puts random numbers in the new cases as values for B.
3. Now add a bunch more cases; e.g. by clicking on row 5’s index and choosing Insert Cases.

Bill

[Author]

Posts