Results 1 to 5 of 5

Thread: Row Total Incorrect Using SumX
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2012
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Row Total Incorrect Using SumX

    I have a simple table and am using sumx, but the row total is incorrect.

    The measure is: =sumx(daily,[Gallons]*[NACVal]/[Acres])/[rows]

    The output looks like this:
    1 2 3 4 5 10 11 12 Grand Total Should be:
    4.807 5.566 2.691 3.266 3.46 16.33
    2.691 2.69 2.69
    3.634 5.382 4.416 3.841 2.691 3.266 4.45 23.23
    4.807 5.566 3.634 4.74 14.00
    4.807 5.566 3.634 3.841 2.691 3.266 4.27 23.80




  2. #2
    Board Regular nikio8's Avatar
    Join Date
    Oct 2017
    Posts
    113
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row Total Incorrect Using SumX

    would you be able to provide screenshot with headers? Perhaps try using brackets, all of your data is in the same row/table, no duplicate rows?

  3. #3
    New Member
    Join Date
    Jan 2012
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row Total Incorrect Using SumX

    A B C D E F G
    1 Date Field Grid MonthVal NACVal Gal Acres
    2 1/10/2019 Ourada, Ken-E 15 1 0.00209 4600 2
    3 1/12/2019 Ourada, Ken-E 16 1 0.00209 4600 2
    4 1/15/2019 Ourada, Ken-E 35 1 0.00209 4600 2
    5 1/17/2019 Ourada, Ken-E 25 1 0.00209 4600 2
    6 1/18/2019 Ourada, Ken-E 27 1 0.00209 4600 2
    7 1/18/2019 Ourada, Ken-E 37 1 0.00209 4600 2
    8 1/20/2019 Ourada, Ken-E 26 1 0.00209 4600 2
    9 1/22/2019 Ourada, Ken-E 38 1 0.00209 4600 2
    10 1/23/2019 Ourada, Ken-A 16 1 0.00209 4600 2
    11 1/23/2019 Ourada, Ken-I 16 1 0.00209 4600 2
    12 1/24/2019 Ourada, Ken-A 1 1 0.00209 4600 2
    13 1/24/2019 Ourada, Ken-E 39 1 0.00209 4600 2
    14 1/26/2019 Ourada, Ken-E 24 1 0.00209 4600 2
    15 1/27/2019 Ourada, Ken-I 17 1 0.00209 4600 2
    16 1/27/2019 Ourada, Ken-I 20 1 0.00209 4600 2
    17 1/29/2019 Ourada, Ken-I 21 1 0.00209 4600 2
    18 1/30/2019 Ourada, Ken-E 36 1 0.00209 4600 2
    19 1/31/2019 Ourada, Ken-I 11 1 0.00209 4600 2
    20 1/31/2019 Ourada, Ken-I 22 1 0.00209 4600 2
    21 2/1/2019 Ourada, Ken-E 17 2 0.00242 4600 2
    22 2/1/2019 Ourada, Ken-I 15 2 0.00242 4600 2
    23 2/2/2019 Ourada, Ken-I 25 2 0.00242 4600 2
    24 2/2/2019 Ourada, Ken-I 26 2 0.00242 4600 2
    25 2/3/2019 Ourada, Ken-E 14 2 0.00242 4600 2
    26 2/6/2019 Ourada, Ken-I 10 2 0.00242 4600 2
    27 2/6/2019 Ourada, Ken-I 12 2 0.00242 4600 2
    28 2/7/2019 Ourada, Ken-E 16 2 0.00242 4600 2
    29 2/8/2019 Ourada, Ken-E 37 2 0.00242 4600 2
    Sheet1
    There are no duplicates - there are multiple entries per day, but they would differ on field/grid combos. The NACVal changes monthly
    Last edited by JNM; May 11th, 2019 at 09:46 AM. Reason: add notes

  4. #4
    Board Regular nikio8's Avatar
    Join Date
    Oct 2017
    Posts
    113
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row Total Incorrect Using SumX

    ok. looking at your data it is unclear what you are calculating. you are trying to save some ram or space not having an extra column, using sumx rather than sum. why do you divide by row?
    i would first create simple formulas, make sure it works and then go on from there. perhaps rows is not connected to this table and you only get total row.

  5. #5
    New Member
    Join Date
    Jan 2012
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row Total Incorrect Using SumX

    I ended up creating a measure for each month, then a measure that added all the months together.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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