cancel
Showing results for 
Search instead for 
Did you mean: 

DEFECT with SUM Data

I have found a case where SUM is working incorrectly.

 

Example1.png

Then I change the field "Time Spent Hours" from "Don't summarize" to "Sum"

example2.png

Once this is switched to "Sum" the value changes from .50 to 11, which is impossible ot explain other than it is a defect.

 

example3.png

 

Please help me with a fix for this as it prevents me from using powerbi for my being useful for summarizing this field.

Status: New
Comments
Moderator

Hi @michael_mcclari

 

Is it possible for you to share the pbix file with us? If it is, please remove sensitive data in report, upload the file to your OneDrive and paste the share link here. 

 

Best Regards,

Qiuyun Yu