Forum Discussion
MarkShnier__You
4 years agoQrew Legend
try this
var text Price = [NPV];
var text Value =
"$" &
ToFormattedText([Price],"comma_dot",3) &
If(
not Contains(ToText([Price]),"."),
".00",
Length(Right(ToText([Price]),"."))=1,"0"
);
If([NPV]<=0,"<font color=\"red\">$" & $Value & "</font>","<font color=\"black\">$" & $Value &"</font>")​
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text Price = [NPV];
var text Value =
"$" &
ToFormattedText([Price],"comma_dot",3) &
If(
not Contains(ToText([Price]),"."),
".00",
Length(Right(ToText([Price]),"."))=1,"0"
);
If([NPV]<=0,"<font color=\"red\">$" & $Value & "</font>","<font color=\"black\">$" & $Value &"</font>")​
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JackWoods4 years agoQrew TraineeI understand the format and know what you're getting at. I'm not sure if I put it in correct.
It tells me I have additional characters past my formula...
Please see screen grab is that right?
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------- MarkShnier__You4 years agoQrew LegendPlease copy and paste your code, so I can see it all and edit it.
Also please post the error message when you save.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JackWoods4 years agoQrew TraineeERROR MESSAGE:
There are extra characters beyond the end of the formula.
"$" &
ToFormattedText([NPV],"comma_dot",3) &
If(
not Contains(ToText([NPV]),"."),
".00",
Length(Right(ToText([NPV]),"."))=1,"0"
) ;
If([NPV]<=0,"<font color=\"red\">$" & $Value & "</font>","<font color=\"black\">$" & $Value &"</font>");
FORMULA:
"$" &
ToFormattedText([NPV],"comma_dot",3) &
If(
not Contains(ToText([NPV]),"."),
".00",
Length(Right(ToText([NPV]),"."))=1,"0"
);
If([NPV]<=0,"<font color=\"red\">$" & $Value & "</font>","<font color=\"black\">$" & $Value &"</font>");
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
Related Content
- 8 months ago
- 9 months ago
- 7 years ago