Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))))) )
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))))) )
Sorry I need or instead of and
Sorry I need or instead of and
i think that "0" shud nt be there
count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='WRKST',
UniqueAB2Key))))) = 0 and if(count(UniqueAB2Key)=0 ,
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))))) )
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)))
awesome.Thank you as always.