Issue in Inputsum where it is showing null values

[koushik_btech20]

In a pivottable I have couple of expression and three dimension. Now in the third expression I am using Inputsum , but after using Inputsum(<FieldName>) I am getting lot of missing record and null values  which was not expected. I tried with , if (Column(1)>=0, 1,0)

as expression condition for that third expression but it is not working properly.

[avinashelite]

Check whether you have associated data with the dimension columns 

[koushik_btech20]

Is there any chance to wrap Inputsum function by num function... because  I saw after wrapping num(Inputsum(<FieldName>),'Numformat') it was not working... could any people share any idea..