Error in formula

[jitendra rai]

What is the err in this formula

If ({CmdMonthlyReport.BASIC_EARNED}="")Then
 formula=ToText ({CmdMonthlyReport.BASIC_EARNED})
Else
 formula=""
End if

What is the solution

[Frinavale]

What is the error that you are getting?
What is the DataType for the formula variable?

-Frinny