Page 1 of 1
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Posted: Sun Aug 01, 2021 11:01 pm
by bayu
This issue still occured in v 1.5.5.
Below is the mmb file so we can test this.
Thanks.
Tester.mmb
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Posted: Mon Aug 02, 2021 3:07 pm
by Renato
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.
Re: Grand Total shows wrong calculation (update v1.5.2 Windows) - FIXED
Posted: Tue Sep 21, 2021 7:09 am
by bayu
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.
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Posted: Tue Sep 21, 2021 4:37 pm
by whall3y
Thanks for the update. Yes we did make a change to fix presentation of large currency values.
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Posted: Tue Sep 28, 2021 4:11 am
by AlexPhilip
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).
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Posted: Tue Sep 28, 2021 6:01 pm
by MartinArmstrong
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).
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?