A little help with a calc field,please!

[Salesman0Gil]

This is the code I have for a Text calc field

GetRepetition( Quantity, 1) & "-" & GetRepetition(item,1) &"

[Salesman0Gil]

I still do not know why it did not work, but I broke it up in to 2 fields, then made a third to combine the two fields and it worked

I would still like to know why it did not work

[EddyB]

Hi,

Without going into your calculation too much, at first glance it seems you have 47 "

You cannot have an odd number of "

It appears to me that you have an extra " here:

"GetRepetition ( Quantity, 3)

Hope this helps

Ed

[Damocles]

Check your calculation....

"&If( (GetRepetition( item, 2) ) <=====

looks like your calculation has an extra close-paren that may be messing up your result. I checked and it is on all the If statements up to 7. In each case, it looks like it will work if you just remove the bolded close-paren from each If statement.

Good Luck

Paul

[Damocles]

Nevermind..... Sorry.

[Salesman0Gil]

Yup, it was that qoute that Eddy B suggested.

Thanks!

One odd thing that has happened. Usually it works fine. For e-mail, it looks just like the text field. Excep for one product that has "Z" as the first letter. This makes no sense to me, but there it is anyway. I just made a special argument, if that came up.