Incorrect results while using 'Treat NULL as Zero' option in Sagent Pivot transform during average and variance calculation

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.


UPDATED: November 22, 2018
This is the expected behavior of the Pivot transform.