Why set expression not giving result ?

[prahlad_infy]

Hello Sirs ,

Below text box expression not giving result

=if(

(    aggr(Count(LOG_ID),EMPLOYEE1)  )=0,          Count(EMPLOYEE1)

)

expected result is 2

Thank You .

PK

[Anil_Babu_Samineni · Accepted solution]

Try this?

Count({<COMPANY1={"=Count(LOG_ID)=0"}>} EMPLOYEE1)

[prahlad_infy]

any other alternative expression ??

just for my learning

[prahlad_infy]

please help me understand why

Count({<EMPLOYEE1={"=Count(LOG_ID)=0"}>} EMPLOYEE1)  gives 0 , an incorrect

but

Count({<COMPANY1={"=Count(LOG_ID)=0"}>} COMPANY1) gives 2  which is correct

and

Count({<EMPLOYEE1={"=Count(LOG_ID)=0"}>} COMPANY1) give 0 , an incorrect