Product Feature: Design Studio
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.
This could be caused due to NULL representing an unknown piece of data and is used as a placeholder for unknown or inapplicable values.
ResolutionUPDATED: November 22, 2018
This is the expected behavior of the Pivot transform.