totext

[codrutza]

Hello

I work with CRXI
Could you help me with this:
I have the formula
if {@year rep}={?Year} then
"Total Month"+" -"+totext({@Month Print})+" "+TOTEXT({?Year},0)
ELSE TOTEXT({?Year}-1,0)
Which brings
… 2,010
… 2,009
The parameter {?@Year} is from the store procedure on sql server and I change the name in {?Year}.
(
I don't know if this helps, but when I print {?Year} it prints
2010
2009
!!!!!
when I print totext, it prints
2,010
2,009
)

I want to have the result
… 2010
… 2009

 

[AndrewBaines]

totext takes extra parameters - try totext({field},0,'')
Something like that anyway

Andrew Baines

http://www.pursuittechnology.co.uk

 

[Turkbear]

Hi,
The full syntax for ToText is here:

http://publib.boulder.ibm.com/infoc...ation.eclipse.designer.doc/html/topic629.html

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[codrutza]

Thank you for the both replies.
I put a formula separated for year without totext, instead the parameter, and now I have 2 formulas (instead of concatenate them in a formula); I used some supress as well; I don't have the formulas with me, because they are at work.

 

[OneArk]

if you wish you can try. Had the same issue with decimal points this morning.

replace(totext({?Year}),",","")

that should remove the comma