I'm not sure if ON A CLEAR DAY YOU CAN SEE FOREVER is considered a flop, especially since there was a movie version and at least one Broadway revival. It only ran 208 performances (no idea whether it paid back its investors). But Barbara Harris singing "Hurry, It's Lovely Up Here" is one of my top-five favorite songs from any Broadway show.
