Pivot table missing values

[#1]

Hi,

When I do a count(fieldname) and I get missing values "-" in my pivot table. How do I replace those with 0s.

I provided a screenshot with the missing values which I would like to replace as 0s.

Thank you

[rittermd]

I have not been able to figure out a way to do that.  I think we are stuck with the '-'.  I have posted the same question previously with no work around.

[#3]

That's a bummer, I hope someone has some insight on this.

[marcohadiyanto]

Hi Ismael,

You can try this expression..

if(count(fieldname)=null(),0,count(fieldname))

Regards,

Marco

[#5]

Hi Marco,

Thanks for the reply. I tried that calculation and still it does not work.

[#6]

Hi Ismael,

It will work this way,

If (Sum(Sales) =0, ' ', Sum(Sales)) in the Pivot expression.

~ Ravi Kancharla

[#7]

Hi Kancharla,

Thanks for replying . I tried that calculation and that didn't work as well .

Ismael