OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » What is #NUM! value in Discoverer?

Home » Applications » Oracle Fusion Apps & E-Business Suite » What is #NUM! value in Discoverer? (Apps: 11.5.10.2-Disco 10.1.2.2 - Desktop 10.1.2.54.25- DB: 9.2.0.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is #NUM! value in Discoverer? [message #282223]

Wed, 21 November 2007 03:47

joselfmp
Messages: 23
Registered: August 2007
Location: Madrid

Junior Member

Hi friends,
I've just migrated from disco 4i to disco 10. For some reports with aggregation values, disco 10 shows values wrong. To correct the failure, I've unchecked in Tools Menu->aggregation tab the "Use the aggregation behavior selected by the Discoverer manager" option. The option now is the "Show N.A. ..."
The problem is that for certain reports, it appear the value #NUM! in aggregation cells and in totals.
I've searched a lot about migraiton problems and I've a SR opened in metalink with this problem for 2 months... but without clarify at all...
Help please... Ideas?

[I've tried to chage the format of cells to all type of format data, but in certain reports it doesn't work and the #NUM! value continues there... For total values.. I have no possibility of change format so.. what to do�?]

Jose L.

Report message to a moderator

Re: What is #NUM! value in Discoverer? [message #282312 is a reply to message #282223]

Wed, 21 November 2007 08:11

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Still, #num indicates that you've set the format to small for the resulting numbers. If you define it's width on the data, that will effect the sum too.

I would suggest to alter the format to some ridicilous number of positions and see what happens.

Report message to a moderator

Re: What is #NUM! value in Discoverer? [message #282358 is a reply to message #282312]

Wed, 21 November 2007 12:08

joselfmp
Messages: 23
Registered: August 2007
Location: Madrid

Junior Member

Hi,
thanks for answer.
The problem is in totals cells and.. It's not possible modify the format for that cells in total lines...
More ideas?

Thanks a lot,
Jose L.

Report message to a moderator

Re: What is #NUM! value in Discoverer? [message #283186 is a reply to message #282358]

Mon, 26 November 2007 05:52

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Like stated: if you alter the format of the data, this will apply to the totals too.

Report message to a moderator

Previous Topic:	complete FA - accouting entries
Next Topic:	can we load prepayments

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 14:00:14 CST 2025