how to ignore null/NA values in the expression values displayed in the pivot table

[Anonymous]

Hi all ,

i have the below given expression in the pivot table , which displays NA or characteristic names in the pivot table.

=IF([Current Rating]-[Requirement Rating]<0,'NA',[Characteristics Name])

i want to ignore the NA values in the expression result and display in the pivot table ,

how can we do this ,?

share any helpful thoughts on this .

Thanks

[chinnuchinni · Accepted solution]

did you try this ?

=IF([Current Rating]-[Requirement Rating]>0,[Characteristics Name])

[Anonymous]

Hi Praveen, 

Thanks for the suggestion..

thinking of all complex ways i didn't try this simple option .

now it works

Thanks a lot.