https://community.qlik.com/t5/QlikView/Formula/m-p/1720226#M723259 <P>this should help</P><LI-CODE lang="markup">=if( if(Count(DISTINCT Department)=0, //0 Departments, then Count(DISTINCT [Sub Dept]), //count distinct sub department, else Count(DISTINCT Department) //count distinct department )=1 //check if result of inner if 1, then ,1 //1, else ,0) //0</LI-CODE><P>&nbsp;</P> Fri, 19 Jun 2020 05:44:59 GMT zhadrakas 2020-06-19T05:44:59Z https://community.qlik.com/t5/QlikView/Formula/m-p/1720208#M723257 <P>Hi All,</P><P>Can please someone explain me&nbsp; how does this below formula works ?&nbsp;</P><P>&nbsp;</P><P>=if(if(Count(DISTINCT Department)=0,Count(DISTINCT [Sub Dept]),Count(DISTINCT Department))=1,1,0)</P><P>&nbsp;</P><P>Thanks in Advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/1720208#M723257 smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Formula/m-p/1720226#M723259 <P>this should help</P><LI-CODE lang="markup">=if( if(Count(DISTINCT Department)=0, //0 Departments, then Count(DISTINCT [Sub Dept]), //count distinct sub department, else Count(DISTINCT Department) //count distinct department )=1 //check if result of inner if 1, then ,1 //1, else ,0) //0</LI-CODE><P>&nbsp;</P> Fri, 19 Jun 2020 05:44:59 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/1720226#M723259 zhadrakas 2020-06-19T05:44:59Z