Sum/Cell Sum Function missing in totals of Discoverer

1574323

Hi All,

I am currently working on Disoverer Desktop 11.1.1.3.0.

I have created a table display report from HR system with payment history. Now i wanted to show group by total for each employee for 2 different element.

When i go to tools-->totals and try to create a new item under calculate LOV i am only able to see Count,Count distinct,minimum and maximum functions.

Why some function is missing in the LOV??

Thanks in advance.

Regards

Sahil Kathuria

Michael Armstrong-Smith

Sahil

The reason you only see those options is because the field is not defined as as being Numeric. You must have defined it as a string.

Edit the EUL and change the properties of the filed to be Numeric and you will see all of the missing aggregation options

Best wishes

Michael

1574323

Hi Michael,

Thanks a lot. I should have added to_number in query itself as even in Admin datatype is grayed out.

After adding to_number for the column, functions are appearing.

Another doubt.. Cant we have exception on total??

Regards

Sahil Kathuria

Michael Armstrong-Smith

Hi Sahil

Sadly no. Exceptions can only be applied to data items not totals.

The only way to do this would be to create a summarized report with only the totals then apply the colored exceptions.

Michael