There are so many variables for this.
If a game is hyped to the level of Halo 3 or Killzone 2 it better sell at least 2 million lifetime.
If a game isn't highly anticipated then as long as it sells a respectable 750k (wii) or 500k (PS3/360) then I don't think you can really call it a flop.