This issue still occured in v 1.5.5.
Below is the mmb file so we can test this.
Thanks.
Grand Total shows wrong calculation (update v1.5.2 Windows)
Moderator: Renato
- Renato
- MVP User
- Posts: 671
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
My calculation would be:
Starting amount 150,000,000 (Old Big House)
Term 19 years
Interest rate in 10%
Final amount 917,386,356.75
Interest 767,386,356.75
I have not calculated the other positions, probably the total is correct, but the individual current values are not.
Starting amount 150,000,000 (Old Big House)
Term 19 years
Interest rate in 10%
Final amount 917,386,356.75
Interest 767,386,356.75
I have not calculated the other positions, probably the total is correct, but the individual current values are not.
Renato Forum Administrator
Re: Grand Total shows wrong calculation (update v1.5.2 Windows) - FIXED
Hi all,
thank you for the updates. Today i update to 1.5.7 and the problem is fixed.
Great job. Thanks alot for dev team for the update.
thank you for the updates. Today i update to 1.5.7 and the problem is fixed.
Great job. Thanks alot for dev team for the update.
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Thanks for the update. Yes we did make a change to fix presentation of large currency values.
-
- New User
- Posts: 1
- Joined: Sun Sep 26, 2021 6:52 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Use a window sum. This would change the total as filters are applied. If you don't want the total to change when filtering, use FIXED.
WINDOW_SUM(SUM([Sales]))
Depending on what pills are in the view, you may need to Edit Table Calculation - Specific Dimensions - and check all dimensions (basically it's saying ignore these fields for the purpose of summing).
WINDOW_SUM(SUM([Sales]))
Depending on what pills are in the view, you may need to Edit Table Calculation - Specific Dimensions - and check all dimensions (basically it's saying ignore these fields for the purpose of summing).
-
- MVP User
- Posts: 300
- Joined: Tue Mar 02, 2021 10:24 am
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
You may well be right in what you say... but it doesn't appear to have anything to do with this topic (or MMEX at all). Wrong forum perhaps?AlexPhilip wrote: ↑Tue Sep 28, 2021 4:11 am Use a window sum. This would change the total as filters are applied. If you don't want the total to change when filtering, use FIXED.
WINDOW_SUM(SUM([Sales]))
Depending on what pills are in the view, you may need to Edit Table Calculation - Specific Dimensions - and check all dimensions (basically it's saying ignore these fields for the purpose of summing).