Skip to Content
0
Former Member
Jul 23, 2010 at 03:42 AM

Cell Definition within a column to show nil

38 Views

Hello All

I have a report with two columns representing actual and budget for time member '2009.TOTAL'.

In the rows, i have specific ten selected accounts 'P_ACCTS'. In the actual column, i wish to exclude two of the ten accounts from retrieving data, IE only the remaining eight should retrive data. All ten rows will be used to send budget data (which i will use EVSND functionality)

I am looking for solutions to exclude the retrival of data from these two cell intersections. My options currently :

1/ Manage the exception cells by including an EVGET that returns '0' - i will save '0' to a data region that is effectively never used to provide this. This will overwrite the column (Actual 2009.TOTAL) and row P_ACCT account intersection retrieval.

2/ Excliude the column from the 'colkeyrange' and for the eight of the ten cells, define an EVGET to retrieve actual data.

Any recommendations to these or other solutions much appreciated,

Glen