Hey! Are you staying home? We are too. Still, we prepared a new product release for you!ūüöÄ

We hope it comes in handy for your business especially these days. Stay safe & pivot on!

How to do conditional formatting on cell.

Open

Thank you whole team for creating wonderful PIVOT table.
while taking average I want to skip zero, so where I should place condition.
I am using below : 

{
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†uniqueName:¬†“Standard¬†changeover”,
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†formula:”if(¬†(‘Standard¬†changeover’)¬†>¬†0,¬†sum(‘Standard¬†changeover’)/count(‘Standard¬†changeover’),0)”,
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†aggregation:¬†“average”,
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†format:¬†“decimal2”,
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†caption:¬†“Total¬†Standard¬†changeover”,
      }

 
But it is not working. please assist.
Attached image for refernce.

Attachments:
Capture.JPG

Please login or Register to Submit Answer