Why formula is showing answers that don't have data?

[Tony88]

Hello,

I have a "Net Grade formula", please see below. The issue is it is showing -4  for the dates that don't have data. Can anybody please tell me why it's showing -4?

Net % w/OOO_Mth = 
DIVIDE(
	SUM('Closes_Assists_KB_NPS_ByMonthByManager (2)'[Closes]) + sum('Closes_Assists_KB_NPS_ByMonthByManager (2)'[WeightedElevations]),
	[ClosedTragetOOOMth]
)

Net Grade_Mth = 
IF([Net % w/OOO_Mth] >= 0.8 , 8,
IF([Net % w/OOO_Mth] >= 0.7 && [Net % w/OOO_Mth] < 0.8, 4,
IF([Net % w/OOO_Mth] >= 0.6 && [Net % w/OOO_Mth] < 0.7, 2,
IF( [Net % w/OOO_Mth] <= 0.5 , -4, 0))))

File

https://drive.google.com/file/d/1dLxmfu3qWBaN6VQCwfCp4oxekbAm69SS/view 

Thank you 

[Tony88]

@amitchandak 

Thank you for the help, but why it does not work with IF tho? 

[amitchandak · Accepted solution]

@Tony88 , Try like

Switch( true() ,
isblank([Net % w/OOO_Mth]), blank(),
[Net % w/OOO_Mth] >= 0.8 , 8,
[Net % w/OOO_Mth] >= 0.7 , 4,
[Net % w/OOO_Mth] >= 0.6 , 2,
[Net % w/OOO_Mth] <= 0.5 , -4,
0)