Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Total number is incorrect

Hello,

 

I need help with the total number.

The Possible error  = Difference * Current Week Outside Pounds Sold. But The total number of them is not correct; the percentage should be 100%, which is incorrect either.

 

 

Thanks

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • dhruvinushah's avatar
    dhruvinushah
    Responsive Resident
    4 years ago

    Hi Anonymous , 

    The possible error field is calculating the SUM of the values in the field. It is doing so accurately. 

    If you want to see the error in terms of Percentages then you can change your calculation or assign a data type of 'Percentage' to the field. 

    Another option is to switch off the Total by removing the aggregation on the field. 

     

    Hope this helps!