topic Re: Pivot table missing values in App Development

Pivot table missing values

Tue, 01 Nov 2016 16:13:39 GMT

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

Re: Pivot table missing values

rittermd — Tue, 01 Nov 2016 16:56:40 GMT

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.

Re: Pivot table missing values

Tue, 01 Nov 2016 17:31:50 GMT

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

Re: Pivot table missing values

marcohadiyanto — Wed, 02 Nov 2016 07:35:16 GMT

Hi Ismael,

You can try this expression..

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

Regards,

Marco

Re: Pivot table missing values

Wed, 02 Nov 2016 15:35:41 GMT

Hi Marco,

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

Re: Pivot table missing values

Wed, 02 Nov 2016 15:51:18 GMT

Hi Ismael,

It will work this way,

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

~ Ravi Kancharla

Re: Pivot table missing values

Wed, 02 Nov 2016 16:31:19 GMT

Hi Kancharla,

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

Ismael