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.
The easiest way to add conditional formatting is to use the toolbar’s Conditional formatting control.
After that, you can save the new config with the “Save” button.
Thanks for best solution, it worked.