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