Hi,
I have a particular report where I have applied a filter to the Hyperblock to avoid displaying records which contain zero values. The zero suppression condition works as expected, except during one particular scenario which I identified.
In this particular report I display GL Accounts for a selected Month and a selected Organization.
Organization GL Account Value
Org_100 GL_Account1 1000
Org_100 GL_Account2 -1000
I want Org_100 along with these two GL Accounts to appear. At the moment they don't appear, I am assuming it's because the two records sum up to zero. Is there a way I can overcome this issue of these two records dropping out?
The required GL Accounts are stored in a XML Format in a Report Variable. The aggregation function used in the XML is Sum. In the filter condition for the Organization Hyperblock I have used this XML Variable for the GL Account Dimension.
Please do let me know if there is a way to resolve this issue.
Thanks in advance!
