Skip to main content
Question

Rich Text Field Loses Currency Format in Pipeline

  • March 30, 2022
  • 0 replies
  • 56 views

I've got a Pipeline that links to my Google calendar. Everything works fine, but I'm losing the currency format on a field. Is there a way to fix this?

------------------------------
Bethany Hudson
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
You would need to convert the number to a text string in a formula field. 

This formula might work

var number Value = Round([My Currency Field],0.01);
var text Decimals = "." & Right(ToText(Int(Abs($Value) * 100)),2);
var text Thousands = If(Abs($Value)>=1000,ToText(Int(Abs($Value)/1000)));
var text Hundreds=Right(ToText(Int(Abs($Value))),3);

If($Value=0,"$0.00",
If($Value<0, "<font color=red>- ")
&
"$" & List(",",$Thousands,$Hundreds) & $Decimals)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------