Forum Stats

  • 3,839,768 Users
  • 2,262,532 Discussions
  • 7,901,053 Comments

Discussions

Sum/Cell Sum Function missing in totals of Discoverer

1574323
1574323 Member Posts: 7
edited Sep 14, 2015 8:51AM in Discoverer

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

Tagged:
1574323

Answers

  • Michael Armstrong-Smith
    Michael Armstrong-Smith Member Posts: 4,403
    edited Sep 13, 2015 11:53PM

    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
  • 1574323
    1574323 Member Posts: 7
    edited Sep 14, 2015 3:05AM

    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
    Michael Armstrong-Smith Member Posts: 4,403
    edited Sep 14, 2015 8:51AM

    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

This discussion has been closed.