Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
9 years ago
Solved

Wrong totals, different than export

Hi.  I have a table in Power BI, that looks pretty good. See pic below.  The problem is on export, the totals in excel are different.  See excel photo at bottom.  So basically the excel document is r...
General Comment
  • Unicorn_Tech's avatar
    Unicorn_Tech
    9 years ago

    I actuall was told by our developer that the problem had to do with summarizing LOV values.   We made this change, and the problem resolved itself. 

  • Unicorn_Tech's avatar
    Unicorn_Tech
    7 years ago

    Hello, I apologize for the delay.  What solved it for us was a simple rounding - surrounding the formula calculating all the numbers with the round formula, to two decimal points.)  This allowed all the sums to add up correctly.

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
9 years ago

I actuall was told by our developer that the problem had to do with summarizing LOV values.   We made this change, and the problem resolved itself. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Hi, I seem to be encountering the same issue. Would you mind elabloriting on the solution to fix this please.

Thanks in advance.

Kind Regards
Bash
  • Unicorn_Tech's avatar
    Unicorn_Tech
    Icon for Resolver I rankResolver I
    7 years ago

    Hello, I apologize for the delay.  What solved it for us was a simple rounding - surrounding the formula calculating all the numbers with the round formula, to two decimal points.)  This allowed all the sums to add up correctly.