What is the function of DISTINCT and NODISTINCT in AGGR function?

[#1]

What is the function of DISTINCT and NODISTINCT in AGGR function?

May be someone can explain to me.

Thanks,

Danny H.

[#2]

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