Error: Unrecognized characters found after number

Hi,

I have to compute the Outstanding amount in a number field which is ‘computed’.

I have two other fields Incurred and Paid .

Formula for Paid field(Number editable) is:

@If(Draft=“Yes”; @Success; Paid =“”; @Failure(“Enter Paid amount.”); @Success)

Formula for Paid_1 (number computed - hidden ) is:

@If(Paid= “”;0;Paid)

------------------------- Similarly the Incurred field also has the same formula.

When I enter the Paid and the Incurred fields, and give a tab to come to the next field, the value of the Outstanding should be computed. But I get the "Error: Unrecognized characters found after number " in the form.

Where did I go wrong ? Can anyone pls help me… ?

Thanks in advance…

Subject: Re: Error: Unrecognized characters found after number

Hi Tulsi,

I’m not really sure but try using @Texttonumber to convert the values you get in Incurred and Paid. That might solve the problem :slight_smile:

Francis Sorreta