If statement, values match another column

[padawanRZ]

Hello,

This might be straight forward but i'm not getting the expected value. The formula yields zero for the name value when i try:

if [Column_Name] = "Name" then [PCT_NonNull]==[Count_Content Name]
else [Column_Name]
endif

From:

Content Name	Column_Name	Count_Null	Count_NonNull	PCT_NonNull	Count_Content Name
abc	Business Description	26	195	0.8824	221
abc	Name	0	221	1	221
def	Name	0	443	1	443
def	PCI-DSS	331	112	0.2528	443
ghi	Name	0	448	1	448
ghi	PCI-DSS	53	395	0.8817	448

To:

Content Name	Column_Name	Count_Null	Count_NonNull	PCT_NonNull	Count_Content Name
abc	Business Description	26	195	0.8824	221
abc	Name	0	221	221	221
def	Name	0	443	443	443
def	PCI-DSS	331	112	0.2528	443
ghi	Name	0	448	448	448
ghi	PCI-DSS	53	395	0.8817	448

[nagakavyasri · Accepted solution]

@padawanRZ