Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the function of DISTINCT and NODISTINCT in AGGR function?
May be someone can explain to me.
Thanks,
Danny H.
Hi Danny,
by default aggregation function is Distinct that is when you code
something like this =aggr(SUM(SALARY) ,Empid ) it means the aggrgation of salary is
done only on distinct records if you want to do it on repeted records like Empid 1001,1002 repaeting more than once
and if you need to take this into account then you have to use a keyword NONDISTINCT
something like this =aagr(NODISTINCT SUM(SALARY),Empid)
then it will sum salary for repeted EmpId
Hope you got the point
Warm regards,
Anant Dubey