Measurement items - Incorrect sum

Looker Q&A Looker Studio
1

If i sum or plus to get certain items delivery count, result is incorrect.
e.g. Item 1 : 50k / Item 2 : 25k / Item 3 : 7k

If i do calculation manually, item 1+2+3 = 82k But if i put formula in Looker studio, result is 45k or something lower than supposed value.

(I bring date from google spread sheet and It is one table. Data type is all numbers)

Is anyone can help troubleshoot this…?
Also if you know if there is any limit of item for sum function, please let me know!

2

@LEE1

Could try with SUM(Item 1)+SUM(Item 2)+SUM(Item 3) please? (assuming that item 1 corresponds to the quantity or a numeric value related to the item)

Mehdi

3

Thank you!
It seems working now.

But do you also have any idea is there limit of component number?
If i add more than 6~7 sum, (sum(item1)+sum(item2)…sum(item7)) then it also stop showing result…