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
------------------------------
Its not showing the [7 Percent Tax Formula] if [Add 7% tax]=true.
But it will show [Taxes] if its filled out, and the "Not Included" if its not.
------------------------------
Megan Hardison
------------------------------
But it will show [Taxes] if its filled out, and the "Not Included" if its not.
------------------------------
Megan Hardison
------------------------------