Skip to Content

why is SUM option missing in Summarized Fields?

Apr 01, 2017 at 07:16 PM


avatar image

The SUM option is not visible in the Summarised field of Crosstab Expert.I did not face this problems in other reports. I could still use MAX but then the TOTAL also becomes a MAX value and not actual sum

Secondly, why is there a space between the columns(red X mark)?

count.png (38.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ido Millet Apr 02, 2017 at 09:56 AM

1. Data type is not numeric

2. CrossTab spans more than one page.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

k it is in fact a numeric data type. In my database marks is stored as decimal number. i am using where i set the marks datatype as 'decimal' in the dataset. By the way in my previous reports, the SUM option was available.


Right-click the Marks field in the field explorer and select Browse Data. What type does Crystal think that field is?


its working now. i really dont have any idea how. i just createsd anew report. thanks anyway. BTW, in browse data, the type is NUMBER now. Thanks