help me with AGGR function

prasoon92 — Thu, 07 Feb 2019 08:40:57 GMT

Hi All,

I need result of this query through Set Expression in the straight table.

select * from Employee where EmployeeName in(select employeename from Employee where Employeename is not null group by employeename having count(contracttype)>1 )

order by EmployeeName

If anyone can help.

Re: help me with AGGR function

pradosh_thakur — Thu, 07 Feb 2019 09:11:39 GMT

sum( {<employeename = {"=count(contracttype)>1"}>}measure)

Try the above may be and supress null in employeename

topic help me with AGGR function in App Development

help me with AGGR function

Re: help me with AGGR function