SUM column after export to excel

julkifli33

hi all....
i already made export to excel (matrix)
now in the last line I want to create a row that is sum all the column
how can i made it?
thanks

jannestig

IS this a custom report you have written or based off one of NAV standard analysis reports?

If its a Standard Analysis report, Even cronus has an example setup you can see.

Sales & Rec > Analysis > analysis Reports

Setup the line you want as a total Select formula and then add the combinations of rows you want added as the totalling formula

julkifli33

i created by myself....

jannestig

Ok What is the report based on Items Value entry etc.

If you look at how the report above does it it should give you what you want

julkifli33

i'm using table item
and then i setrange by date
so i have matrix like this

1/1/11 2/1/11 3/1/11 ............. 10/1/11
Item A 1 7
Item B
Item C 2
Total 3 7 0 ............. 0

the one i'm asking is the bold one

David_Singleton

Just insert '=SUM(C3..C24)' in the field.

julkifli33

David Singleton wrote:

Just insert '=SUM(C3..C24)' in the field.

we can get the first row... like you said C3
but how about last row?
how can i get the last row numbers? --> C24

David_Singleton

julkifli33 wrote:

David Singleton wrote:

Just insert '=SUM(C3..C24)' in the field.

we can get the first row... like you said C3
but how about last row?
how can i get the last row numbers? --> C24

Count them.


If you start at C3 and then you insert 21 rows you end at C24.

julkifli33

David Singleton wrote:

julkifli33 wrote:

David Singleton wrote:

Just insert '=SUM(C3..C24)' in the field.

we can get the first row... like you said C3
but how about last row?
how can i get the last row numbers? --> C24

Count them.


If you start at C3 and then you insert 21 rows you end at C24.

but how do i catch the column?
i mean C,E,F
i dont know until what column
it depends on user give parameter

David_Singleton

julkifli33 wrote:

David Singleton wrote:

julkifli33 wrote:

we can get the first row... like you said C3
but how about last row?
how can i get the last row numbers? --> C24

Count them.


If you start at C3 and then you insert 21 rows you end at C24.

but how do i catch the column?
i mean C,E,F
i dont know until what column
it depends on user give parameter

What have you tried so far. There is enough information for you to do something by yourself. Simply asking on forums is never going to help you. Except in the very short term.

crisnicolas

Mmmm... you said the number of columns depends on user parameters... but... given the parameters... you do know how many columns and how many rows have been exported, right? And you probably know in which column you want to add the SUM, right?
I don't see where the problem is... of course you cannot use a 'SUM(C3:C24)' like this, harcoded, you'll have to build this string dynamically, but other than that...