Text Box value

Question

I have 3 text boxes (A, B, C)
C = A - B BUT the answer must always be 0 if the A - B produce a negative number.

I know I can do this with a button, but is there a way to do it without one.  Like write a function under Default Value?

Thanks for the help.

Answer 1

Sure, use rules.

On box B, create these rules that say

If A is not empty and B is not empty and A-B < 0, then set field C's value to 0
If A is not empty and B is not empty and A-B >= 0, then set field C's value to the formula A-B

There may be more you want to do, but those should work without the need for a button or default value.

---

SharePoint Architect || My Blog

Answer 2

Here it is ....

Can be used as default value.

c = (a>b)*(a-b)

---

http://alecpojidaev.wordpress.com

Answer 3

Alec, what does that mean?  What is A>B in mathematical calculations?

---

SharePoint Architect || My Blog

Answer 4

The result of a>b is casted to the integer range [0:1] if logical opertation is part of algebraical formula.

---

http://alecpojidaev.wordpress.com

Answer 5

I don't understand how that works the way you wrote it.  What you wrote is a simple multiplication of two things, one of which is not a value unless I'm missing something.  Is there a function missing to do that check?

Edit:  I guess not...how does that work without a function?

Still probably good to add a condition that they're both not blank since it defaults to 0 when one or both is blank.

---

SharePoint Architect || My Blog

Answer 6

Understanding is overrated.  Just accept the fact that it's working :)

---

http://alecpojidaev.wordpress.com

Answer 7

You know I can't leave it at that!!  =P  It definitely DOES work, though.

---

SharePoint Architect || My Blog

Answer 8

Very nice!   Thank you!

Answer 9

Very nice!   Thank you!

For what it's worth, Alec's is more efficient and concise.  It can also be used as a default value to minimize logic and effort.  I appreciate the answer credit on mine, but Alec's is much better as long as you include conditional logic.

---

SharePoint Architect || My Blog

Answer 10

Dahey , Don't encurage people to stop being nice please put your mark back to his answer :) His answer was correct and he tryed to be helpfull.

---

http://alecpojidaev.wordpress.com

Answer 11

Yeah, there can be more than one answer, so it doesn't have to be one or the other.

---

SharePoint Architect || My Blog