Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below logic ,but I am not sure how to put this together.The bold one's are the new ones I need to add to the already existing logic.Not sure how I can add that within multiple if's.Any help is highly appreciated.
if(AB1OccupancyCount =0 ,
if(AB1BuildingCpacity >= 0 ,
if([AB1BuildingCpacity(Manual)]= 0 , sum([AB1BuildingCpacity]),SUM([AB1BuildingCpacity(Manual)]))))
else
if(AB1OccupancyCount >0 ,
if(AB1BuildingCpacity > 0 ,
( 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(distinct (UniqueAB2Key)) =0,
sum([AB1BuildingCpacity(Manual)]),
COUNT(distinct (UniqueAB2Key))))
Thanks
Alva.
Please provide sample data and expected output