Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can please someone explain me how does this below formula works ?
=if(if(Count(DISTINCT Department)=0,Count(DISTINCT [Sub Dept]),Count(DISTINCT Department))=1,1,0)
Thanks in Advance
this should help
=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
this should help
=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