Skip to Content
0
Former Member
Jun 29, 2009 at 03:39 PM

#ixGetData Error: Invalid use of Null

33 Views

Hi,

I am running a basic XL Reporter report and I am getting Other Data for the Territory. It pulls through data for a records that have a territory but when it reaches one that is Null it creates the error above.

I presume I need to use the condition in 'Get Other Data' but everything I try it doesn't like.

Does anyone have any idea's of what condition to use to return " " if Null.

I have tries standard SQL but it doesn't seem to work.

thanks

Mark