Compare Two Periods Report

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)

Moderator: Renato

User avatar
Renato
MVP MMEX User
Posts: 466
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Compare Two Periods Report

Post by Renato »

Renato wrote: Sat Dec 03, 2022 8:16 pm I prefere generate a report directly into MMEX.
No such evaluation is provided, but you can submit a request at https://github.com/moneymanagerex/money ... +is%3Aopen.
Due to the many number of requests and little programming capacity it will take some time.

Information to PIvot, you can read: https://support.microsoft.com/en-us/off ... 9134456576

Note: Unfortunately, the CTRL+c function does not work in the "All transactions" report, otherwise it would be possible to transfer the selected transactions to Excel in a simple way. See: https://github.com/moneymanagerex/money ... ssues/5394
regards Renato use MMEX since 2009, now with Windows 11
MartinArmstrong
Super MMEX User
Posts: 197
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Compare Two Periods Report

Post by MartinArmstrong »

Renato wrote: Sun Dec 04, 2022 1:15 pm Note: Unfortunately, the CTRL+c function does not work in the "All transactions" report, otherwise it would be possible to transfer the selected transactions to Excel in a simple way.

See: https://github.com/moneymanagerex/money ... ssues/5394
@Renato, as a workaround you can do this:

1. Go to the All Transactions view.
2. File | Export | HTML Files and save the file (xxx.html)
3. Open xxx.html in Excel, or just drag it into an open worksheet. You now have the transaction data, as you would have if you did copy/paste.
User avatar
Renato
MVP MMEX User
Posts: 466
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Compare Two Periods Report

Post by Renato »

Hi @MartinArmstrong
thanks for the tip, but the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
regards Renato use MMEX since 2009, now with Windows 11
MartinArmstrong
Super MMEX User
Posts: 197
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Compare Two Periods Report

Post by MartinArmstrong »

Renato wrote: Sun Dec 04, 2022 4:09 pm the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
I don't have that problem because my thousands separator in Windows and in MMEX is a comma.
excel_cjoDozss90.png
excel_cjoDozss90.png (54.88 KiB) Viewed 1187 times

If you want to use a space thousands separator in Excel (while keeping your Windows thousands separator in other applications), then in Excel:

- Click File > Options
- Click Advanced
- Under Editing Options, clear the check box Use system separators
- Click in the Thousands separator box
- Enter a space
- Click OK
ZWk11YhV3I.png
ZWk11YhV3I.png (120.37 KiB) Viewed 1187 times
Last edited by MartinArmstrong on Sun Dec 04, 2022 8:11 pm, edited 1 time in total.
User avatar
Renato
MVP MMEX User
Posts: 466
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Compare Two Periods Report

Post by Renato »

Hi @MartinArmstrong
Thank you very much, I did not know, has worked perfectly. :D :roll:
regards Renato use MMEX since 2009, now with Windows 11
Post Reply