Product Feature: Design Studio
Issue
While using PIVOT transform in Sagent, when the 'Treat NULL as zero' option is selected during the average and variance calculation, the sentences with NULL are considered as zero.
Cause
This could be caused due to NULL representing an unknown piece of data and is used as a placeholder for unknown or inapplicable values.
Resolution
UPDATED: November 22, 2018This is the expected behavior of the Pivot transform.