Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I met an issue with the sum function.
I have 2 data rows as the image.
The column 1 and 2 are dimension. But when I use the sum in column 3, it show duplicate value.
Could anyone explan to me what is the reason for this? Thank in advance.
For sum getting double its data is two times in loaded table.
also
There is atleast 1 another dimension column in that table
or the values in those dimension are numerical timestamp but made into integere which means those are different values but you cant see them unless you format them correctly, try using floor for this case.
try sum(distinct
Thanks. But I want to know why the sum of dimension shown duplicated value. Its weird!
For sum getting double its data is two times in loaded table.
also
There is atleast 1 another dimension column in that table
or the values in those dimension are numerical timestamp but made into integere which means those are different values but you cant see them unless you format them correctly, try using floor for this case.
Thank Gabbar,
I use the disinct load and the issue was solved.