Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting for currency symbol position

Status
Not open for further replies.

flailcozy

Technical User
Dec 4, 2007
18
US
Does anyone know the formatting syntax for setting up conditional formatting for the currency symbol position?
I am using Crystal 10. I would like it to have a leading position for businesses in the US and a trailing position for businesses in France.

Below is the (successful) formula I am using to set currency symbol, and I'm thinking I would use the same formula, but replace the dollar and Euro symbols with whatever the trailing/leading formatting syntax is:

switch ({LAB.lab_country} = "USA", "$",
{LAB.lab_country} = "France", "€",
True, "$")

thanks in advance, jc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top