Daisy If statements

George,

If(
  [Total Gross Billed Amount: BoM Ordered]=0,
  0,
[Gross BoM Ordered Balance]*0.5)

if(
  [Total Gross Billed Amount: BoM Ordered]>0,
  0,
  [Gross BoM Ordered Balance]) ​

You've got these two statements in there which contradict one another.

Let's examine what would happen if BoM Ordered was 1, 0, or -1.

If BoM ordered is  1, the first statement would return '[Gross BoM Ordered Balance]*.5' and the second would return 0.

If BoM ordered is  0, the first statement would return 0 and the second would return [Gross BoM Ordered Balance].

If BoM ordered is -1, the first statement would return '[Gross BoM Ordered Balance]*.5' and the second would return 0.

So these are incompatible, if you want them to return in the same statement. If you can tell me what the formula should return for BoM ordered being 1, 0, and -1, the formula can be combined.

If you need more help with it, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.

Sign up here:
https://data.quickbase.com/db/bqeqqj33i

------------------------------
- Sam

______________________________________________
Sam Jones
Vice President, Product and Technology
he/him

The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------