You are not logged in.

Consolidate elements : sum doesn't work.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Jackybob

Professional

  • "Jackybob" is male
  • "Jackybob" started this thread

Posts: 16

Date of registration: Aug 18th 2006

Location: France

  • Send private message

1

Thursday, September 7th 2006, 12:01pm

Consolidate elements : sum doesn't work.

Hello,

I've got a problem again (maybe my last ;) ). I've got an Excel sheet with 5000 lines, and one line with a consolidate element. Here is a "view" of my Excel sheet :

Quoted


__________|| _2001 || 2002 || 2003 ....
_All sellers ||#####||#####||#####
seller 00001 || 10000 || 18952 || 15446
seller 00002 || 11100 || 12562 || 14364
seller 00003 || 08912 || 08154 || 10545
seller 00004 || 21614 || 19985 || 20345
...
seller 04800 || 23453 || 22123 || 25789



Why the consolidate values are not calculated?
(I think it comes from the modelisation because with others databases, it works).

Thanks

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

2

Thursday, September 7th 2006, 4:17pm

RE: Consolidate elements : sum doesn't work.

Sorry if I ask. But is it possible that its just a problem of excel column width? /:-)

This post has been edited 1 times, last edit by "h_decker" (Sep 7th 2006, 4:17pm)

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 454

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

3

Friday, September 8th 2006, 10:28am

RE: Consolidate elements : sum doesn't work.

Hi!
Try simply resizing columns so that values can fit inside cells.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

Jackybob

Professional

  • "Jackybob" is male
  • "Jackybob" started this thread

Posts: 16

Date of registration: Aug 18th 2006

Location: France

  • Send private message

4

Friday, September 8th 2006, 11:31am

It is a shame for me.... ;(
Thanks.. I feel very stupid :P
==>>

Jackybob

Professional

  • "Jackybob" is male
  • "Jackybob" started this thread

Posts: 16

Date of registration: Aug 18th 2006

Location: France

  • Send private message

5

Friday, September 8th 2006, 3:59pm

I use this thread to ask another question :

With PasteView

When I try to paste a big table (4000 lines, 84 columns, cells contains numbers like "25 000"), Palo can't display it. With and without consolidate elements.

When I want to paste the view, there is a question message :

Quoted

The selected view contains more than 10000 cells. Do you want to restrict the view to 119 rows? (recommended)

=> Yes / No


Sometines, it is 109 or more... When I choose "No" Excel crashes.

Questions :
1) How is calculated the number "119"? Is it in relation with memory (RAM)?
2) Why, when I chose "No" (=I do not want to restrict the view) do Excel crash? Is it again in relation with hardware?
3) Is there a solution to display all data?? I want, for example, to know the sales of my 4000 commercials per month, during the last 7 years (12 months * 7 years = 84 columns)... is it possible?

Thanks

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 454

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

6

Friday, September 8th 2006, 5:32pm

Hi!
Crash is definitely not a desired thing. What exactly do you mean by crash?

Generating large views can take time … that’s why we check if a fairly large amount of cells with Palo formula is displayed before we generate the view. This is why you see that message. The number 119 is a calculated from 10 000 / number of columns, or if it is easier:
119 * number of columns = < 10000.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

Jackybob

Professional

  • "Jackybob" is male
  • "Jackybob" started this thread

Posts: 16

Date of registration: Aug 18th 2006

Location: France

  • Send private message

7

Friday, September 8th 2006, 5:57pm

OK, I understand for the number.
The crash is :
Just after clicking on "Paste", I wait, at a moment (quick) the message upper with the question of displaying all cells or not.
I choose NO (=all cells), and just here : Freeze... 10 minutes later, a message from Excel appears (translated from French):

Quoted


Microsoft Office Excel encountered a problem and has to be closed. Please apologize us for the trouble

This message contains two buttons with "Send the error rapport" and "do not send" (again translated from French).

After that, Excel is closed.
Rate this thread