[LON-CAPA-users] (no subject)

[lon-capa-users@mail.lon-capa.org]

I am playing with my scoring mechanism in the spreadsheet again, and tried
the line below.
It of course gives the standard "undefined value" response.

Anyone know what the error is?

The stores_0_tries value is blank or empty; all the rest of them have
numbers in them.

[&EXPANDSUM(PART;stores_PART_tries=1?6:(stores_PART_tries=2?2:(stores_PART_tries=3?0:-2)))]


Since I don't really understand the syntax, I have tried various
combinations:

[&EXPANDSUM(PART;[stores_PART_tries]=1?6:([stores_PART_tries]=2?2:([stores_PART_tries]=3?0:-2)))]

[&EXPANDSUM(PART;['stores_PART_tries']=1?6:(['stores_PART_tries']=2?2:(['stores_PART_tries']=3?0:-2)))]

[&EXPANDSUM(PART;'stores_PART_tries'=1?6:('stores_PART_tries'=2?2:('stores_PART_tries'=3?0:-2)))]

[&EXPANDSUM(PART;"stores_PART_tries"=1?6:("stores_PART_tries"=2?2:("stores_PART_tries"=3?0:-2)))]



all with the same results.

Thanks,brew