<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://community.sageaccpac.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General Discussion</title><link>http://community.sageaccpac.com/forums/9.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2007.1 SP1 (Build: 30415.43)</generator><item><title>Excel Report</title><link>http://community.sageaccpac.com/forums/thread/1626.aspx</link><pubDate>Tue, 14 Apr 2009 18:12:10 GMT</pubDate><guid isPermaLink="false">8c320e6c-c1a2-4353-93c8-95785067d6bc:1626</guid><dc:creator>pabloisl</dc:creator><slash:comments>0</slash:comments><comments>http://community.sageaccpac.com/forums/thread/1626.aspx</comments><wfw:commentRss>http://community.sageaccpac.com/forums/commentrss.aspx?SectionID=9&amp;PostID=1626</wfw:commentRss><description>&lt;p&gt;I have developed a income statement by department and I want to add the current location name and segment number atop the report.&lt;/p&gt;
&lt;p&gt;My current account code is as follows;&lt;/p&gt;
&lt;p&gt;Account number - 00000&lt;/p&gt;
&lt;p&gt;Region - 00&lt;/p&gt;
&lt;p&gt;Department - 000&lt;/p&gt;
&lt;p&gt;what must my formula be to display e.g &amp;quot; 900 - Accounts&amp;quot;&lt;/p&gt;
&lt;p&gt;Any help will be greatly appreciated.....&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>