Logic help Please

[#1]

Please find attached file

[ThornOfCrowns]

Is this the same query as:

Expression logic help please

If so, please try to keep your replies or additional comments to the same thread as it makes it easier to follow.

Thanks.

[sunny_talwar · Accepted solution]

Try this:

=Count({<[RM RoomType] = {'WRKST', 'OFFICE'}, [EM EmployeeName] = {"=Len(Trim([EM EmployeeName])) > 0"}>} [EM EmployeeName]) + Count({<[RM RoomType] -= {'WRKST', 'OFFICE'}>} [RM RoomType])

[MK_QSL]

=Count(

  {

  <[RM RoomType] = {'WRKST', 'OFFICE'}, [EM EmployeeName] = {"=Len(Trim([EM EmployeeName])) > 0"}>

  +

  <[RM RoomType] -= {'WRKST', 'OFFICE'}>

  }

  [RM RoomType])

[#5]

Thank you.This did magic

[#6]

Thank you.Yopur logic was very helpful.