2 Replies Latest reply on Sep 2, 2014 8:11 PM by DingoCC DingoCC

    Override 'All' in the title

    DingoCC DingoCC

      My sheet title is:  Yearly enrolments in the <Industry> industry for the <Region 10> region

       

      Region 10 is used on a polygon map.  With no polygons are selected the value of Region 10 defaults to 'All', which results in a title of "Yearly enrolments in the Retail Trades industry for the All region".  My wish is to display "Yearly enrolments in the Retail Trades industry" when the Region 10 values is All, and display "Yearly enrolments in the Retail Trades industry for the Hume region" when a polygon is selected.

       

      I've tried a case statement in a calculated field, which in turn is used in the title, however the 'All' passes right through the case and seems to ignore it all together.  Suggestions?