Alpha Video Training
Results 1 to 3 of 3

Thread: Live Excel Formula

  1. #1
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    643

    Default Live Excel Formula

    Hello

    I've watched Selwyn's video(s) on using the live excel formula summing totals and sub totals. Is the a way to Average instead of Sum?

    Thanks

    -John

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,353

    Default Re: Live Excel Formula

    Hi John,

    I am unaware of the video(s). My knee-jerk reaction is to say use average instead of sum, but I don't
    know how valid that is without seeing the video.

    Gregg

  3. #3
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    643

    Default Re: Live Excel Formula

    Hi Gregg,

    Video https://www.viddler.com/v/1d862bb0

    Basically A5 fills in the formula.

    In the report under the Excel property, A5 puts in SUM({@col}{@startComponent_name}:{@col}{@endComponent_name}) where Component_Name is my grouping field.

    if I change that to Average({@col}{@startComponent_name}:{@col}{@endComponent_name}))

    then in the spreadsheet I get the error: incorrect token in formula:Average(J1:J84).

    SUM works fine though.

    Thanks

    -John

Similar Threads

  1. Write to Excel, read results of a formula
    By CampnJim in forum Mobile & Browser Applications
    Replies: 8
    Last Post: 04-14-2019, 04:47 PM
  2. Excel export not working in live preview/localhost
    By Peter.Greulich in forum Application Server Version 11 - Web/Browser Applications
    Replies: 10
    Last Post: 01-06-2012, 04:49 PM
  3. Converting Excel Formula
    By Steviev in forum Alpha Five Version 10 - Desktop Applications
    Replies: 9
    Last Post: 05-29-2011, 11:27 AM
  4. Formula Help
    By lionking15 in forum Alpha Five Version 9 - Desktop Applications
    Replies: 4
    Last Post: 04-27-2009, 11:07 PM
  5. formula help
    By John Burke in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-26-2004, 06:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •