Need help in Formula Field

[Former Member]

Hello,

I got this error

I dont know how to fixe.

Please help

[Former Member · Accepted solution]

James

You can't write the If statement in that position.

It cannot stand by itself like that in crystal.  ( that's why crystal is confused by the ")" .   It doesn't know how to interpret  what you wrote. )

  you need to  Incorporate the "if"  after the last "="  to   replace the Column6_1 field in the last line with the if statement.     

Ted

[Former Member · Accepted solution]

Hello Ted,

I can't imagine what you said. Can you coaching me - What the code should looks like?

[former_member205840 · Accepted solution]

Hi James,

Can you try this :

Whileprintingrecords;

Numbervar column6_1;

If {DataTable1.DataColumn3} = Left({DataTable1.DataColumn4},3) &"00" Then

(

Column6_1:=column6_1+(If isnull({DataTable1.DataColumn6}) Then 0 else Toumber({DataTable1.DataColumn6})

)

Thanks,

Sastry

[abhilash_kumar · Accepted solution]

Hi James,

Your code is almost perfect!

You just need a semicolon after the 'else':

else

(Column6_1_1 := {DataTable1.DataColumn6}) ; //You're missing this semicolon

-Abhilash