can anybody suggest a workaround?
if a room is designated as a double, i would like an occupancy to count it as 2. the rest is counted as 1 and will just add the similar type rooms as its total.
IF (Name = "DB", Count*2, Count)
i'm trying to avoid to create another column that is manual entry just to get this to work.
thanks in advance.
danny