Going nuts, need another pair of eyes.

I have an unstored calculation field u_Foo, defined as follows (this is in debug form, don't worry about intentions)

-- Has 5 repetitions.

-- Let ( [k = Get ( CalculationRepetitionNumber ) ] ; Case( k = g_SortColumn ; k ; -1 * k ) )

g_SortColumn is a global number from 1 to 5.

When g_SortColumn = 1,

u_Foo[1] = 1

u_Foo[2] = -2

u_Foo[3] = -3

u_Foo[4] = -4

u_Foo[5] = -5

as hoped.

But when g_SortColumn = 2,

u_Foo[1] = -1

u_Foo[2] = -2 <-- expected 2

u_Foo[3] = -3

u_Foo[4] = -4

u_Foo[5] = -5

Same for g_SortColumn = 3..5

It's like the test (k = g_SortColumn) succeeds when both are 1, but not when both are 2, 3, etc...

Can anyone spot the problem? Thanks....Chap

You need to use Extend ( g_SortColumn ).

BTW, -1 * k = -k

Thanks!