Sum Function

[neerajthakur]

Hi, why am I getting Sum([Quantity Numbers]) this much high what all can be the reasons for it.

[Mark_Little]

Hi

Would need to share more information around both the data and model to get a meaningful answer.

My guess if it is to high is there is a problem in the data model, you have caused duplicate lines, but it is a guess.

[khaoulaaa]

Hi @neerajthakur ,

Lines are duplicated . by default straight table shows unique records  so you can't identify duplication. to be sure try to create table with [consignement ID item Code] as dimension and count([Quantity Numbers]) as measure. and the best way is to share with us your loading script.