Forum Discussion
JackWoods
5 years agoQrew Trainee
I 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
------------------------------
It tells me I have additional characters past my formula...
Please see screen grab is that right?
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
MarkShnier__You
Qrew Legend
5 years agoPlease 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
------------------------------
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
------------------------------
- JackWoods5 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
------------------------------- MarkShnier__You5 years ago
Qrew Legend
Can you use the whole formula I posted? You left out part of it. But in any event here is a better version to use.
var text Value =
"$" &
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>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JackWoods5 years agoQrew TraineeThank you - that worked. sorry for the confusion.
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
Related Content
- 8 months ago
- 8 months ago