Formatting Printed Parameter Ranges 1

[slimshades26]

Crystal 8.5

The below varied formula was retrieved from the forum. I need it to be formated with no demicals or thousand comma.
It forced me to make it a string so that it why I have "ToText" in there. If I attempt to divide the parm it starts asking for "a number or currancy amount is required here". Any suggestions? Thanks!

{@PartRange}

"From: " + ToText(Minimum ({?Part#})) +
" To: " + ToText(Maximum ({?Part#}))

Result of formula is: From: 0.00 To: 9,999,999.00
Wanted Result is: From: 0 To: 9999999
ss26

 

[Naith]

Slim,

You need yourself a ,0 between your )).

Naith

 

[slimshades26]

Amazing! Thx ss26

 

[slimshades26]

I jumped the gun a bit. I still have the thousand commas. Can we remove those also? Thx. From: 302,000 To: 332,500 ss26

 

[synapsevampire]

replace(ToText(Minimum ({?Part#})),",","&quot

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[slimshades26]

synapsevampire:

did not quite do the trick...it asks for a closing ")":

(ToText(Minimum ({?Part#}))),",","&quot

then when it is added it says "the remaining text does not appear to be part of the formula" and the cursor is directly after the added closing paren. leaving the commas and quotes hanging as well as the next line of maximum. Thanks for your response. Do you have another approach? ss26

 

[synapsevampire]

You don't have the replace in there???

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[slimshades26]

Thank you very much for your patience! I did not know that replace was a "function". I thought you were suggesting I replace with the following portion. Wonderful. I added Naith's ,0 between my )) to cut back the decimals. Thx again both of you. ss26

 

[synapsevampire]

No worries, slim, glad it worked for you.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Hm786]

Can't we get the same result by using this formula
"From: " + ToText(Minimum ({?Part#}),'####') +
" To: " + ToText(Maximum ({?Part#}),'####')

Thanks,
Hamida

 

[Ngolem]

you don't need a replace function just this will work

{@PartRange}

"From: " + ToText(Minimum ({?Part#}),0,"","&quot +
" To: " + ToText(Maximum ({?Part#}),0,"","&quot

this gets rid of a decimal place and thousand separator and has no decimals

Jim Broadbent

 

[synapsevampire]

I think both of yours are more efficient than what I posted, though I think ngolems always resolves even if the number hits millions.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com