Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,I have problem for sum(KDV).
Normaly write182,9463 in Sum(KDV) part but write irrelevant number in that part. If someone can help me ,i would be glad
Hey Murat,
Here is the result that you are looking for. I created another expression with Sum(Distinct KDV):
Since KDV repeats for "Teppich Traum" multiple times, you need to use Distinct in Sum() function. If you don't use Distinct, it will just sum all KDV values. That's why you were seeing aggregated KDV amount.
Hope this helps.
Thanks
Other useful links by Sinan:
It would be easier to help if you post your qvw
Preparing examples for Upload - Reduction and Data Scrambling
Thanks for you interest.
Which value are you supposed to see when summing KDV? 182,95?
Hey Murat,
Here is the result that you are looking for. I created another expression with Sum(Distinct KDV):
Since KDV repeats for "Teppich Traum" multiple times, you need to use Distinct in Sum() function. If you don't use Distinct, it will just sum all KDV values. That's why you were seeing aggregated KDV amount.
Hope this helps.
Thanks
Other useful links by Sinan:
Yes 182,95
I can see your values repeat all over your data, maybe avg(KDV) instead of summing will return what you want
Thank you so much.( Çok Teşekkür ederim )
This is solution for me .
But normally kdv has one record or I can see one records.so I dont understand why this happening why 5,488