Only count Specifc Values

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

I need to count the total number of rooms at the end of the report. I have
each room type counted already at the end of the report. I only want to
count the values of "Singles", "Doubles" and "Triples", I want to exclude the
room type "Exclude" for the total room count. Below is the code I'm using

=-Int(-Sum(Abs([RoomValue])))

I have "Singles", "Doubles" and "Triples", in the value list in the
properties section however it is still adding "Exclude" in the calculation.
Any idea how I can count just the three room types. Thank you in advance for
your assitance.
 
What about grouping your report by RoomType. Then you will just need the sum
in the group footer.
Or if that isn't appropriate, why not create a totals query and include that
in your report as a subreport? You could filter out Exclude in this
subreport. The advantage of this is if a new Roomtype is added, the report
would automatically reflect that without you having to edit your text box.


Evi
 
Assuming a field called NoOfRooms that contians the number of rooms for each
line of data, then control source in the Report Footer:

=Sum(iif([Values]<>'Exclude',[NoOfRooms],0))

If there is only one room per line of data then you can change the above to:

=Sum(iif([Values]<>'Exclude',1,0))


That should do it.
 
Back
Top