SI.EXPANDGLHISTORY displays "null" instead of an empty cell

Applies to

• Velixo NX

• Sage Intacct

Overview

The SI.EXPANDGLHISTORY function returns “null” for cells whose values are empty in Sage Intacct instead of displaying empty cells:

Cause

This is expected behavior that occurs to ensure the usability of the SI.EXPANDGLHISTORY function for providing Dimension values for balance functions, for instance, SI.TURNOVER.

In functions like this, an empty Dimension value indicates that the balance formula should completely ignore that Dimension. This would mistakenly account for both the transactions that specify this Dimension (any value) and transactions that don’t.

Providing “null” instead ensures that we only sum up transactions where that Dimension was not specified.

This behavior is discussed in more detail in the Special Cases section of the Using Dimensions guide.

Workaround

Should you not want the “null” values to be visible in your workbook for aesthetic or other reasons, apply conditional formatting to render the text white (and thus indistinguishable from its background) whenever a value of a cell is equal to “null”: