Forum Discussion

Begbie's avatar
Begbie
Icon for Helper I rankHelper I
3 years ago
Solved

Matrix Totals are not correct

Hello good people of the PBI community.   I need some help please to understand why my matrix visual is showing incorrect totals ğŸ¤”   I have a relatively simple matrix of the rows made up of:   ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Begbie 

     

    There is no error in the calculation of total cost, but the Average column has decimals omitted.

    As shown in the figure, this is an unindented decimal. The calculation is correct.

    This is the data after the decimal point is omitted. 2.06*145<>298.44, but 145 itself is not 145.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Begbie 

 

There is no error in the calculation of total cost, but the Average column has decimals omitted.

As shown in the figure, this is an unindented decimal. The calculation is correct.

This is the data after the decimal point is omitted. 2.06*145<>298.44, but 145 itself is not 145.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Begbie's avatar
    Begbie
    Icon for Helper I rankHelper I
    3 years ago

    Thank you for taking the time to reply and show the working out.

     

    I'm embarrased to say, you are totally correct. I adjusted my report to show the decimal places in the average day and now the figures all tie up ğŸ˜³