David, Try Display > Amount > Double (default is ’Single’)
I’m not sure why this works when both debit & credit columns are visible, and not when only the credit column is visible, but it does. I have my Global preference for Sign Reverses set to ‘Credit Accounts’ and I set the report to ‘Global Preference’. Regards, Adrien > On Aug 12, 2019, at 12:00 AM, David T. via gnucash-user > <[email protected]> wrote: > > Hello, > > I am trying to create a YTD Capital Gains report, and am encountering a > problem with how the Transaction Report implements the Sign Reverses setting. > > I recall some time back a discussion about the fact that the Sign Reverses > setting reverses signs in these reports in a confusing way. There was some > discussion about reversing the individual transactions but not the totals. > Although I do not recall the specifics of the discussion, I am encountering > the same situation now, where the transactions themselves respect the user > setting, but the totals do not. To say this is confusing is an understatement. > > It seems to me that other financial applications must have encountered the > problem of displaying income to users as a positive value (since that is how > most of us view income!) while still finding a way to display the correct > accounting information. > > To display my YTD report of Capital Gains, I ran a Transaction Report and > selected the Income:Realized Gains accounts for the current year. The result > shows losses as positive numbers, and gains as negative. I don't know about > you, but my expectation is reversed from this. If I change the Sign Reverses > setting to Income and Expense, then the transactions switch, but the totals > do not. This result was the gist of the discussion in an earlier thread. > Bleah! > > Now, I know that I can copy the data, paste it into another program and > change all the settings to my heart's content, but I am looking for a way to > run a report in GnuCash that directly and unambiguously shows me whether I > have gained money (a positive) or lost it (a negative) over the current year. > Does anyone have suggestions? > > FWIW, I attempted to turn this report around and have a report that lists > transactions in the asset accounts, filtered by the Income:Realized Gains > accounts, but that seems to report only the Asset account currency--in this > case, the mutual fund or stock shares involved on the Gain/Loss transaction. > Unfortunately, that's not the actual Gain/Loss value... > > It would be nice if the sign reverses setting could be fixed. Barring that, > does anyone have a workaround report setup that can give me a sensible YTD > Capital Gains total as described? > > David T. _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
