Using IF statement not resulting in correctly summed data

Using the following formula to combine two measures:   NS Act+Proj = if([NS Act Total]=0,[NS Proj Total],[NS Act Total])   What I want it to do is create a column where "When [NS Act Total] is ze...