Your camera on auto white balance is going to do its best to remove your filter's color cast. At any rate, one of the first things you should do with your D100 is get the white balance off AUTO. First, it doesn't work all that well. Second, it's not terribly reproducible, not even for the same image shot more than once. Third, you can't control it.
For shooting in daylight, Most D100 users are using CLOUDY-3 or SHADE+3. These settings are very close to what you would expect for daylight film. You can adjust your WB setting to meet your lighting needs, or to create a mood for a particular shot. (For example, using a setting of Incandescent at twilight will create an intense blue cast that confers an impression of impending darkness or extreme cold.) If you shoot RAW files, you even get a bonus of being able to change the WB later in case you forgot to change it to the appropriate setting. (Or experiment with alternative settings to get the right color balance for what you have in mind.) Most importantly, you regain control over your images.
If you want to exert fine control over the white balance, you can use a chart to convert the iconized Nikon settings to approximate color temperatures. Higher temperature settings result in warmer images; Lower temperature settings result in cooler images.