If statement help please

[#1]

IF(Seats-((count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                           +

      count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) = 0     and if(count(UniqueAB2Key)=0 ,  

SUM([AB1OccupancyCount(Manual)])),

Seats-((count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                          +

        count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) )

I have the above expression and Once I add 'and if(count(UniqueAB2Key)=0 ' it throws me error.

How can I put that and statement for the first part?

Thank you very much.

[sunny_talwar]

May be try this:

IF(Seats-((

  count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                           +

      count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) = 0     and count(UniqueAB2Key)=0, 

SUM([AB1OccupancyCount(Manual)])),

Seats-((count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                          +

        count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) )

[#3]

Sorry I need or instead of and

[#4]

Sorry I need or instead of and

[Chanty4u]

i think that "0" shud nt be there

count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) = 0    and if(count(UniqueAB2Key)=0 , 

[sunny_talwar · Accepted solution]

Then replace and with or

IF(Seats-((

  count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                          +

      count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) = 0 or count(UniqueAB2Key)=0,

SUM([AB1OccupancyCount(Manual)])),

Seats-((count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                          +

        count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) )

[sunny_talwar]

You can also try this:

=If((Seats - Count({<[EM EmpName] -= {'*'}>}, [RoomTypeAssigned]= {'OFFICE', 'WRKST'}>} UniqueAB2Key)) = 0 or count(UniqueAB2Key) = 0,

(Seats - Count({<[EM EmpName] -= {'*'}>}, [RoomTypeAssigned]= {'OFFICE', 'WRKST'}>} UniqueAB2Key)))

[#8]

awesome.Thank you as always.