Export to Excel Total Column Formula

sendoh
sendoh Member Posts: 207
edited 2008-03-13 in NAV/Navision Classic Client
hi guys,

is it possible to export to excel with column formula, i checked the function filtertoformula in excel buffer table and it seems only the row total formula are there by using this '..' range.

this is what I'm trying to achieve.

Account no. | Name | 01/01/08 | 020108 | Total-here is the formula
700.090.98 | Expense | 300.00 | 200.00 | 500-here is the formula
700.090.99 | Expense | 500.00 | 200.00 | 700-here is the formula

please help...
\thanks
Sendoh
be smart before being a clever.

Comments

  • easabangan
    easabangan Member Posts: 114
    Ricky boi,

    Simply just use the excel buffer table to export in excel. And for the formula use the SetFormula function.
    No future at CPI
  • sendoh
    sendoh Member Posts: 207
    the formula is just a sum of the column not the row.. how to achieve this?
    Sendoh
    be smart before being a clever.
  • ajhvdb
    ajhvdb Member Posts: 672
    Can't you use export the literal value:
    =C3+D3
    Create dynamic Excel or Word documents, ReportX
  • sendoh
    sendoh Member Posts: 207
    what is the possible way? any suggestion?
    Sendoh
    be smart before being a clever.
  • jonsan21
    jonsan21 Member Posts: 118
    Using the literal value is possible when using automation.
    Rgds,

    Jon.
  • sendoh
    sendoh Member Posts: 207
    Using the literal value is possible when using automation.

    give me some hints..

    I'm on the Budget-> export to excel.. when exporting it, the formula in total column should be add..
    Sendoh
    be smart before being a clever.

Categories