[b] ToText - Rounding [/b]

[jrcol12357]

CR XI - I have a Cross Tabs fields I wish to label base on nulls or a value. I'n not able to come up with the correct statement. I keep rounding up, for example 0.125 returns 0.130, .075 returns .080. Current formula:

if isnull ({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT}) then 'Non - Goldstar'
else totext({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT},"#.000")

 

[dgillz]

Try this:

if isnull ({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT}) then 'Non - Goldstar'
else totext(round({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT},3))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jrcol12357]

Thanks.. I tried that with the same results,I get:
Non - Goldstar 0.00
0.80 (sum of group)

I would need
Non - Goldstar 0.00
0.075 (sum of group)

 

[lbass]

Can you clarify whether you are using this formula as a row versus a summary field?

-LB

 

[jrcol12357]

As a Row Name. The Row Name can comes back as many different values. .125, .075, 1.000. If the value come back as 0.00 I want the row to show "Non - Goldstar

 

[CoSpringsGuy]

if your original number is formatted as .075 then try:

totext({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT},3)

You shouldnt have to tell it how to format the number

Crystal Reports XI Developer

 

[jrcol12357]

That's it. Thank so much. Now I can move on to other assigments.