"Total" function gives an incorrect result

You can find a report with an example and explanation here: https://flex.bi/bi/accounts/47/cubes/HansaWorld%20Invoices/reports/1882-alternative-for-total-function-not-working-correctly