[RESOLVED] A currency amount is required here ???

[DubweiserTM]

Hi everybody !

In my table there are 3 fields (Description / Check / Cout)

If the value of Check is true I want the amount in Cout and if it's false I want that "Exclus" appears on the report instead of the amount ???

I add the code below in Formula editor:

If {TravChantier.Check} = "True"
Then {TravChantier.Cout}
Else "Exclus"

I got the error "A currency amount is required here"

I understand the error, but I dont know how to do what I want ???

Thanks in advance !

[brucevde]

A formula can only return 1 datatype. Use the ToText statement to convert the currency field to a formatted string.

If {TravChantier.Check} = "True" Then
   ToText({TravChantier.Cout})
Else 
   "Exclus"

[DubweiserTM]

A formula can only return 1 datatype. Use the ToText statement to convert the currency field to a formatted string.

If {TravChantier.Check} = "True" Then
   ToText({TravChantier.Cout})
Else 
   "Exclus"

Thanks for this information, Im very new with CR !