Currency Symbol in Revenue Columns of Business on the Books Export
umesh parhi
started a topic
over 4 years ago
Since 5.17, the Business on the Books report when exported to a CSV file prints the currency symbol just before the amounts in all columns having financial data. Now, for some of the currency symbols which probably are not in UTF-8 format, it is not possible to do any arithmetic sum using Excel formulas. Simply highlighting the cells also does not show the sum at the bottom of the sheet. Changing the format of the cells to number or currency also does not help.
One such currency is Swedish Krona which has a symbol of Kr. The only way to sum the data in those columns is by using the Replace function to replace the Kr. with blank and then use the sum function.
As not all currency symbol have this issue, we would like to request to add a report filter for the Business on the Books report indicating whether the user would like to have the currency symbol printed. If selected to print then it will print else it will not print. This will then meet the requirements of all hotels who would like to have the currency symbol or not have the currency symbol.
Since 5.17, the Business on the Books report when exported to a CSV file prints the currency symbol just before the amounts in all columns having financial data. Now, for some of the currency symbols which probably are not in UTF-8 format, it is not possible to do any arithmetic sum using Excel formulas. Simply highlighting the cells also does not show the sum at the bottom of the sheet. Changing the format of the cells to number or currency also does not help.
One such currency is Swedish Krona which has a symbol of Kr. The only way to sum the data in those columns is by using the Replace function to replace the Kr. with blank and then use the sum function.
As not all currency symbol have this issue, we would like to request to add a report filter for the Business on the Books report indicating whether the user would like to have the currency symbol printed. If selected to print then it will print else it will not print. This will then meet the requirements of all hotels who would like to have the currency symbol or not have the currency symbol.
Freshdesk ticket: https://stayntouch.freshdesk.com/a/tickets/59210
Jira ticket: https://stayntouch.atlassian.net/browse/CICO-77632
Issue reported by: Story Hotel Riddargatan