Here is an Excel equation that might be useful for anyone developing Sage Intelligence reports and want to show the name of the selected tree reporting unit in the title of the report.
=IF(ISERROR(FIND("">"",$B$2)),$B$2, RIGHT($B$2,LEN($B$2) - FIND(""|"",SUBSTITUTE($B$2,"">"",""|"",LEN($B$2)-LEN(SUBSTITUTE($B$2,"">"",""""))))))
For Example the equation will display ""CECILIA'S AREA"" from the reporting unit ""ABC AC TREE>COMBINED P&L>KEGAN'S MARKET>CECILIA'S AREA""
The Equation is looking at the reporting unit name stored in cell $B$2. Do a search and replace $B$2 with your reporting unit cell location.
Enjoy.
Doug