SI.EXPANDGLHISTORY displays "null" instead of an empty cell
Created by Wojtek Rajtar, Modified on Wed, 30 Apr at 10:40 AM by Wojtek Rajtar
Applies to
Velixo NX
Sage Intacct
TABLE OF CONTENTS
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”:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article