Have 0013457 to show just as 1

[grecon]

Hi I want to have my ORDER_ID (which looks like 0013457 or 0024657)to just show as the number 1 is there a formula I can use to show that? Thanks

 

[dgillz]

If {Order_ID}="0013457" then "1" else {Order_ID}

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[grecon]

How about if I want to do it for all the ORDER_ID's ?

 

[fisheromacse]

or if you have multiple order numbers you want to assign to '1' use:

If {Order_ID} in [0013457,0024657] then "1" else {Order_ID}

 

[grecon]

I do have mutiple numbers like 20, can I use a range value? Like 0013457 - 00224657

 

[fisheromacse]

If your order #'s are sequential and numeric?

ie: if you order #'s are all like this:
1001, 1002, 1003, 1004, 1009, 1010, 1022, 1033, 1056, etc
and you want only 1002, 1003, 1004, 1005, and 1006 --you can use something like this:

If {Order_ID} in [1002 to 1006] then "1" else {Order_ID}

 

[lbass]

Why do you want to do this? I think knowing your goal would help.

-LB