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

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, 2018
This is the expected behavior of the Pivot transform.