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