If Then Else help String versus Number

[AndreaEllis]

I have a formula I am trying to write...

If {field} (which is a number) = {Field2} (which is a string. I need to pull the first 4 characters from the second field)
then {field 3}
else {field 4}

I am having an issue getting the field and field 2 to work like I am thinking it should.

Andrea

 

[CrystalizeCanada]

Hi Andrea

If totext({field})={field2} then {field2}[1 to 4]

you need to compare apples to apples so if I understand correctly just convert the number field totext.

You may have to add totext({field},0) to control the number of decimals or totext({field},0,"")and whether there is a thousand seperator.

First just play with the totext function so you understand what your number looks like when converted to text.

Gordon
Crystalize

 

[AndreaEllis]

Gordon,

Thank you very much that works great!!!

Andrea