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
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