Replacing '-' with '0' in pivot table

[Abhi999]

I Used below expression but still it is showing '-'.

IF(ISNULL(count(order))='-', 0,count(order))

[Durgadevikumar]

Hey Abhi,

IF(ISNULL(count(order))='-', 0,count(order))

If the order field having multiple null values(-) then count of order produce the count is does not gives the (-) . so automatically it provides the count of order as a output.

So Try this simple if condition,

=if(Order = '-', 0 , count(Order))  // if the order field has - it replace those value with 0 or else give the count of order

Regards,

Durga