Compare Two Periods Report

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

User avatar
Renato
MVP MMEX User
Posts: 651
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
Renato Forum Administrator
MartinArmstrong
MVP MMEX User
Posts: 300
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: 651
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.
Renato Forum Administrator
MartinArmstrong
MVP MMEX User
Posts: 300
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 5350 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 5350 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: 651
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:
Renato Forum Administrator
Noelok
New MMEX User
Posts: 13
Joined: Tue Oct 25, 2022 12:31 pm
Are you a spam bot?: No

Re: Compare Two Periods Report

Post by Noelok »

MartinArmstrong wrote: Sun Dec 04, 2022 6:32 pm
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.
Hi - How did you get MMEX to use comma as thousands separator? That would help me a lot!
Post Reply