Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
on my model i got a wrong result on Sum function.
as far as i know i don't have duplicated rows
after using Load Distinct on the relevant joined tables on the "DW", the problem seemed to be solved
was i doing the right thing? is that a good solution?
that's the "before" stage.
Sum needs to be equal to NetoWeigt
Date | Lot | NetoWeight | Sum |
2017-05-22 | G0136267 | 24300 | 72900 |
Thanks
Avner
Hi,
Looks like data become 3 times more than actual data.
check any wrong join which you did in your script.
Regards,
or try below expression
sum(aggr(Distinct sum(NetoWeight),Lot))
Regards
can you share the exact expression with data?
Tanks for all of your replies
Checked the script and the process again
and found out that even if select only few fields, i need to use Distinct.
otherwise i end up with multiple lines, even if i can't see them.