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

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 !

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

Code:

---

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

---

Quote:

---

Originally Posted by brucevde

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

Code:

---

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

---

---

Thanks for this information, Im very new with CR !