If field is blank then

[Anonymous]

Hi all,

In Report View, I've added New Column with a calculation. 

To find area = (IF(Overview[SGP]=1,"SGP","")&"/"&IF(Overview[MSIA]=1,"MSIA","")&"/"&IF(Overview[JPN]=1,"JPN","")&"/"&IF(Overview[AMS]=1,"AMS",""))

I reached a couple of results such as "///AMS" or" //JPN/AMS" which are fine. But for this result "///", is there anyway I can change to "Not in Area" instead? 

I would need all of them to be able to put into Slicer visualisation..

[v-huizhn-msft]

Hi @Anonymous,

Could you please create sample table and list expected result for further analysis?

Thanks,
Angelia