Category
Broadcast & Report Export
Product Version
9.0
broadcast report in excel format makes all the number columns a text format
Awaiting Reply
Currently when I broadcast a report in excel format and the recipient opens the report, the metrics show as text. The recipient then need to change the format to number. How do I broadcast a report that will make the metrics formatted as number?
The same question
Hello Steve,
My name is Chegudi Priya from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:
Ticket Number: #32286-04-14
Case Title: Broadcast report in excel format makes all the number columns a text format
Please allow us some time we will get back to you shortly. If you have any further questions or need assistance, please reach out to us. We're here to help.
Thanks & Regards,
Priya.
Hello Steve,
My name is Chegudi Priya from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:
Ticket Number: #32286-04-14
Case Title: Broadcast report in excel format makes all the number columns a text format
Please allow us some time we will get back to you shortly. If you have any further questions or need assistance, please reach out to us. We're here to help.
Thanks & Regards,
Priya.
Hello Steve,
Could you please check the column formatting settings in your report . If the column is not in numeric format you can format the columns as numbers in the report, which might help in retaining the number format when broadcasting.
Thank you for your patience, Could you please confirm the field was in numeric format as shown below
Hope this helps, Please update me on the results so we can proceed with the investigation.
Thanks & Regards,
Priya.
Hello Steve,
Could you please check the column formatting settings in your report . If the column is not in numeric format you can format the columns as numbers in the report, which might help in retaining the number format when broadcasting.
Thank you for your patience, Could you please confirm the field was in numeric format as shown below
Hope this helps, Please update me on the results so we can proceed with the investigation.
Thanks & Regards,
Priya.
Hello Steve,
I have conducted tests on my side, and everything is functioning properly without any issues. I have also included a video demonstrating my replication of the process. It is possible that I may have overlooked something based on your description. Therefore, could you please provide a video recording of the issue? This would be very helpful.
Thanks & Regards,
Priya.
Hello Steve,
I have conducted tests on my side, and everything is functioning properly without any issues. I have also included a video demonstrating my replication of the process. It is possible that I may have overlooked something based on your description. Therefore, could you please provide a video recording of the issue? This would be very helpful.
Thanks & Regards,
Priya.
Hi Priya,
The column is numeric in the column formatting. I played around with the column formatting. I turned off the "thousands separator" and the column appeared in Excel as numeric! I think that this should be fine, but it would be nice if it appeared as numeric in Excel with commas.
Steve
Hi Priya,
The column is numeric in the column formatting. I played around with the column formatting. I turned off the "thousands separator" and the column appeared in Excel as numeric! I think that this should be fine, but it would be nice if it appeared as numeric in Excel with commas.
Steve
Hello Steve,
I have conducted tests on my side, and everything is functioning properly without any issues. Could you please provide info.jsp and a video recording of the issue.
Thanks & Regards,
Priya.
Hello Steve,
I have conducted tests on my side, and everything is functioning properly without any issues. Could you please provide info.jsp and a video recording of the issue.
Thanks & Regards,
Priya.
Hello Steve Kay
I wanted to follow up with you regarding the information I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.
Thank you,
Chegudi Priya
Yellowfin Technical Support
Hello Steve Kay
I wanted to follow up with you regarding the information I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.
Thank you,
Chegudi Priya
Yellowfin Technical Support
Replies have been locked on this page!