CHAR type characteristics can not be converted to numbers and sum

[former_member780997]

I created a report by using free-hand SQL as a data provider in the Business Objects 5.1 enviroment . However, I found that the CHAR type characteristics can not be converted to numbers and sum. For example, the AMT is a measure object with the CHAR type including the two character string: 20 and 15.33 in the report. I would like to get 35.33 with the following function formula

=Sum(To_Number(<AMT>)) .

Actually, I only get the 2015.33 with the above formula. I assumed that the sum formuls herein means the concatenation character string. The AMT type should not be updated in the free-hand SQL as a data provider.

Could you please help me how to obtain the correct adding result ,35.33 in this report ? Many thanks!

Best regard

Agiler

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.