Column total of exported data is different to matrix total

[Anonymous]

Hi Everyone,

I am facing an issue where if I export my matrix table to excel the column sum totals i get is way different to the matrix totals. Any ideas?

Kind Regards

Bash

[Anonymous]

Just to give abit more context to the problem, the values are correct in the rows but the total is off as seen below. If adding all the values up it should come to 55 however it is totalling to 53. I have tried the sumx formula however still no luck. Please assist

[v-juanli-msft]

Hi @Anonymous 

I make a test but i can't reproduce your problem.

Could you check my example and  modify with your example?

Or could you make a simple test file and share with me via onedrive (upload file to onedrive and share the link here)?

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft ,

Im not sure how to make test file since this is clients information, can I perhaps provide screen shots ?

Kind Regards

Bash

---

[v-juanli-msft]

Hi @Anonymous 

Ok