Trying to format with 2 decimal places
I have a Formula Rich Text field to display a grand total. If the cents end in 0 like .10 it drops the final 0. Here is my formula "<p style=font-size:14pt;color:red;><b>"& "$" & ToFormat...
Forum Discussion
Hi Julie,
Here's 3 examples of how I've done this in a metric report.
If(IsNull([January]),"No Actuals",
Case(
[Measurement],
"Total",
"<div style='color: " & If([January] < [Metric Monthly Objective],"#FF0000",[January] >= [Metric Monthly Objective],"#228B22") & "'>"&If([Metric Type]="Currency","$")&ToFormattedText(Round([January],0.01),"comma_dot")&Case([Metric Type],"Currency","","Percent","%")&"</div>",
"Financial",
"<div style='color: " & If([January] < [Metric Monthly Objective],"#FF0000",[January] >= [Metric Monthly Objective],"#228B22") & "'>"&If([Metric Type]="Currency","$")&ToFormattedText(Round([January],0.01),"comma_dot")&Case([Metric Type],"Currency","","Percent","%")&"</div>",
"Average",
"<div style='color: " & If([January] < [Metric Monthly Objective],"#FF0000",[January] >= [Metric Monthly Objective],"#228B22") & "'>"&If([Metric Type]="Currency","$")&ToFormattedText(Round([January],0.01),"comma_dot")&Case([Metric Type],"Currency","","Percent","%")&"</div>",
ToText([January])
)