Hi All, ,
I am using the export dse to excel smart service. One column in db having decimal values but when exported to template it Removes the decimal part. Although I have formatted the column to number decimal in the template but it is not working. Can anyone please suggest some solution.
Many Thanks!
Discussion posts and replies are publicly visible
We did suggest you something on this thread - https://community.appian.com/discussions/f/new-to-appian/29104/modify-values-in-a-queryselectionDid you give it a try?
The issue with Excel is, that it tries to be clever on how to display values. When importing or exporting data with Appian to or from Excel it is always a challenge to get things right.
Yes Stefan it is surely a challenge. Any suggestions to display decimal values while exporting to excel?
The issue seems to be with data type in cdt. In database the column data type is decimal and in cdt it is number(decimal as well) but when querying using cdt it truncates the decimal part in result.
I am pretty sure that the data is truncated on its way into the Excel. Please make sure that it is not just some display hiccup in Excel.
Hi Stefan,
I tried to fetch the data in exp rule and there also the decimal part is truncated. The value is of 8 digits might be causing the issue.
No. Keep in mind that Appian always formats the values when displayed. What you see in the expression test output might NOT be the real value including all digits.
okay, any suggestions to fix this issue to get proper data into excel?
You have to check the data in Excel first. And I mean in-depth. Unzip the Excel and check the XML file. If, and only if, the data in that XML is not as expected, it makes sense to try to fix something in Appian.
Yes, I checked in xml data is in decimals there but in excel it is not. Looks like it is bug in smart service.