Formatting Integers In Expression

[ericp]

Hello, I have created an IIF statement to tell me whether values have 'Stayed the same / Increased / Decreased'. However, in my IIF statement, I'm unable to format the integer values so that the sentences can support formatting.

This one is an example of my IIF statement:

{IIF(Projects_CurrentProjectRevision.ChangedTotalAmount>0, "Total Project Cost increased from $"+ (Projects_CurrentProjectRevision.TotalCost-Projects_CurrentProjectRevision.ChangedTotalAmount) + " to $" + Projects_CurrentProjectRevision.TotalCost.

I have also attached my mrt file

[Lech Kulikowski]

Hello,

You can use the following expression:
{IIF(Projects_CurrentProjectRevision.ChangedTotalAmount>0, "Total Project Cost increased from $"+ (Projects_CurrentProjectRevision.TotalCost-Projects_CurrentProjectRevision.ChangedTotalAmount) + " to $" + String.Format("{0:C2}", Projects_CurrentProjectRevision.TotalCost), IIF(Projects_CurrentProjectRevision.ChangedTotalAmount<0, "Total Project Cost decreased from $"+ (Projects_CurrentProjectRevision.TotalCost-Projects_CurrentProjectRevision.ChangedTotalAmount) + " to $" + String.Format("{0:C2}", Projects_CurrentProjectRevision.TotalCost),
"Total Project Cost stays the same $"+ String.Format("{0:C2}", Projects_CurrentProjectRevision.TotalCost)))}

Thank you.