Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Removing decimals for numeric field

I have a field year which is string type coming from db side.So I converted that to number and adding 1 more year to that to show like this:


Below is the formula.

'Year' & ':' & tonumber({FocusOnCustomer.YEAR})&'-'&(tonumber({FocusOnCustomer.YEAR})+1) 

Everything is working fine in designer.But when I view the report in cr viewer I am getting data like this.


I want to remove decimals and comas

Former Member

Hi Kalyan,

Change the code to:

'Year' & ':' & totext(tonumber({FocusOnCustomer.YEAR}),0,"") &'-'& Totext((tonumber({FocusOnCustomer.YEAR})+1),0,"")


1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question