Joined: 20 May 2010
Online Status: Offline
Posts: 5
Topic: Re: Error Posted: 08 Jul 2010 at 9:08am
Hi Gurus,
I am getting the error 'the remaining text doesn't appear to be a part of formula' when I check the following in a formula. Could you please correct it ? In the below mentioned 'Emp' field is string type and I want to convert it in to number.
(IF {X.Emp}= '100' then {X.Emp}= 'Null' else ToNumber({X.Emp}) )
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 08 Jul 2010 at 9:19am
First off, it appears you are trying to set a database field a value, you cannot do that. If you want to assign a variable a value you use the ":=" , "=" is for comparison. Here is what I think you want to do.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
