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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article