Skip to Content

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

Formating Problems using CSTR Function

Hi,

i am using the following formula to search and publish values within crystal Reports using a collector:

This is the coding which works fine with normal numbers:

select{HQ_HMCOPA01_ERG3_BOCRE.Abweichungen COPA BOCRE}

case "Abweichung zum Vorjahr %" : (

s_8 :=           cStr(Round(Val({HQ_HMCOPA01_ERG3_BOCRE.01. Umsatz})),0)

)

default : dummy := "0"

;

{HQ_HMCOPA01_ERG3_BOCRE.Abweichungen COPA BOCRE};

The above mentioned formula has also been used to round up a percentage value.

In BEX it looks like this "screenshot 1":

The original percentage number has been formated within the Query and rounded.

-191,077546761 will be 191,1

This is the result that I need in Crystal as well.

In Crystal I get the following number:   -191.077546761 (it sets an . instead of an ,

So if i use my function above the result will be "screenshot 2"

Any ideas?

Thanks for your help

Screenshot 1.gif (2740 B)
Screenshot 2.gif (1683 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question