AnsweredAssumed Answered

TextStyleAdd function issue with Dollar amounts

Question asked by imgaryshap on Jun 15, 2010
Latest reply on Jun 16, 2010 by imgaryshap

Title

TextStyleAdd function issue with Dollar amounts

Post

I am using FMP 8 on a MAC.

 

I have a field where the user can manually enter the budget called Production Cost Per Episode (ProdCPE).

 

I have another field with a drop down selection called Budget Type where the user can select either "Working" or "Contractual"

 

When I run a report, I would like the following to happen:

When Budget Type is "Working", ProdCPE will appear in Italics.  When Budget Type is "Contractual" it will remain as is.

 

I also want the number format to appear in dollars $123,456   (with the dollar symbol and no decimals)

 

I figured out how to get the number to appear in italics using the following calculation:

 

If (Budget Type="Working"; TextStyleAdd(ProdCPE;Italic); ProdCPE)

 

However, in order for this calculation to work, I have to remove the dollar formatting from the field so my numbers are just appearing as entered:    123456   rather than: $123,456

 

Any suggestions on how to maintain the dollar formatting along with the change in style to italics?

 

Thanks so much!

 

-G.

Outcomes