This formula keeps the Asset type the same and changes all other types to Liabilities & Owners Equity.<\/p>\n The next step is the most important: displaying the account balances. After all, without numbers the report would mean nothing. However, if you just drag and drop the {@Amount} formula onto the report, all the balances will be wrong. You can’t just display the account balance on the report because all numbers are stored in the database as positive numbers (even the negative numbers). You need to write a formula that determines whether an amount should be negated or left as a positive number.<\/p>\n There are two things that determine the sign of an amount. The first is its account type and the second is whether it is a debit or a credit. If you recall, you have to use the rules in Table A-1 to determine which numbers are positive and which are negative. In the next step, I give you the formula that does this.<\/p>\n This formula first looks at the account type and then it looks at whether the number is classified as a debit or credit. Using Table A-1, when the account type is Asset and the value is a debit, it increases the account value. Thus, the formula returns a positive number. When the account type is Asset and the value is a credit, it decreases the value. The number is negated by multiplying it by -1. The formula uses the opposite for the other accounts (as dictated by Table A-1).<\/p>\n You should note that the Expense account doesn’t follow the rules in Table A-1. According to Table A-1, expenses are treated the same as the Asset accounts, but this formula doesn’t do that. This is because expenses are included in the Net Income calculation and they must be combined with revenues. This is a special circumstance that we’ll learn more about later in this tutorial.<\/p>\n The amount needs to display a sub-total in each group footer. This summarizes the data at each level. The next three steps walk you through adding each sub-total.<\/p>\n Let’s look at the report to see where we are so far. If you preview it, you should see something similar to the next two figures. I split the report into two separate figures so that it is easier to read. Figure A-6 is the Assets section and Figure A-7 is the Liabilites & Owners Equity section.<\/p>\n There is an initial problem with the current report layout. There are too many account types listed. If you look back at Figure A-4, you’ll see that there are only two account types: Assets and Liabilities & Owners Equity. This corresponds to the Accounting Equation we discussed earlier. Another way to think about it is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,1],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-appendix-a-financial-reporting","category-crystal-reports-xi","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}if {Account_Type.Account Type}=\"Asset\" then<\/code>
\n \"Assets\"<\/code>
\n else<\/code>
\n \"Liabilities & Owners Equity\"<\/code><\/p>\n\n
if {Account_Type.Account Type} = \"Asset\" Then<\/code>
\n if {Journal_Entry.Debit Or Credit} = \"Debit\" Then<\/code>
\n {Journal_Entry.Amount}<\/code>
\n Else<\/code>
\n {Journal_Entry.Amount} * -1<\/code>
\n Else<\/code>
\n if {Journal_Entry.Debit Or Credit} = \"Credit\" Then<\/code>
\n {Journal_Entry.Amount}<\/code>
\n Else<\/code>
\n {Journal_Entry.Amount} * -1<\/code><\/p>\n\n
\n
\n ![](\"http:\/\/www.crystalreportsonlinetraining.com\/Images\/CRXI\/ApdxA\/image013.png\")
<\/img><\/a>
\n Figure A-6. Balance Sheet preview showing the Assets section.<\/b>
\n
\n <\/img><\/a>
\n Figure A-7. Balance sheet showing the Liabilities & Owners Equity section.<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"