forums

I have 11 calculated fields for each record. Each uses a case statement to determine it's value. I also have another calculated field that sums up the other eleven.

I do not seem to be able to show that last field as numeric field in my chart.

Example
One of the 11 fields is called "MatrixAlignmentPre" it is based on a dropdown box in Access and saves either a null, 0, 1 or 2

the case statement is as follows-
CASE [AlignmentPreWS]
when 0 then 0
when 1 then [AlignmentPreWS]
when 2 then [AlignmentPreWS]*8
else null
end

the other ten are the sam using different Access fields.

The final field "MatrixTotalScore"

and has a calculation of -
sum([MatrixAlignmentPre]+[MatrixCompellingVisionPre]+[MatrixDataAvailablePre]) (and 8 more)

When I drag that to the drop column it doesn't stay.