Appending Zeros to the groupname field

[reacha]

I have grouped by a field called gate1 and now when i want to append the groupname field with zero's

Groupname field should be 5 digits

Ex:

89 - 00089
452 - 00452

Please help me out!!




Thanks,
reacha

 

[IanWaterman]

Convert to text

totext(yournumberfield, "00000",0,"")

if already text

totext(tonumber(yournumericstring), "00000",0,"")


Ian

 

[reacha]

Thanks for your help

 

[lbass]

FYI--the following is sufficient, without the additional 0,"".

totext(yournumberfield, "00000")

Also, you should just be using your group field in the formula, not the groupname field. I have never had a reason to use the groupname field myself.

-LB

 

[reacha]

when i scheduled the report in business objects enterprise to the specific FTP server then i am not getting the zeros that i have appended to the groupname field



Thanks,
reacha