If formula
I need help writing a formula please. Hopefully super easy... If([Add 7% tax]=true,[7 Percent Tax Formula],[Taxes]) But then I want to add that if [Taxes]=0, then display "Not Included". Than...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendMegan,
The challenge here is that when you define a formula field in QuickBase it needs to be a type like Text or Numeric. You seem to be wanting a result which is sometimes numeric and sometimes text.
In your use case can you have a formula numeric field that will calculate to a numeric result and then have a separate text field to put in the form that says "Taxes not included". That's the easy way through this.
There is a way to coax the numbers into a text field if you want to pursue that direction, but it will be more complicated than you expected. But we can go down that path together if you want to work your way through it on this Forum.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The challenge here is that when you define a formula field in QuickBase it needs to be a type like Text or Numeric. You seem to be wanting a result which is sometimes numeric and sometimes text.
In your use case can you have a formula numeric field that will calculate to a numeric result and then have a separate text field to put in the form that says "Taxes not included". That's the easy way through this.
There is a way to coax the numbers into a text field if you want to pursue that direction, but it will be more complicated than you expected. But we can go down that path together if you want to work your way through it on this Forum.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yes, I can do the easy way, but I need EF+ to display on the printout "Taxes not included" if its $0. Maybe its a formula with the EF+ form itself?
------------------------------
Megan Hardison
------------------------------
------------------------------
Megan Hardison
------------------------------
- MarkShnier__YouOK, I get it. I will post back later when I get a chance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__YouI have not tried this in the formula editor but try this
// calculate the numeric value
var number TaxesCalc =
If([Add 7% tax]=true,[7 Percent Tax Formula],[Taxes]);
// turn the calculated value into text with two decimals.
var number Value = Round($TaxesCalc,0.01) ;
var text Decimals = "." & PadRight(Right(ToText(Int($value * 100)),2),2,"0");
var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));
var text Hundreds=Right(ToText(Int($Value)),3);
var text NumberInTextFormat =
If($Value<0, "-")
&
List(",",$Thousands,$Hundreds) & $Decimals;
// decide which to show
IF([Taxes]=0, "Not Included", $NumberInTextFormat)
// if the formula does not work and your can't debug it, please post your formula and the error message
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------