[RESOLVED] How do I Sum Blank Value

Hi all I have one question here...Can someone please guide me how to make this formula.Im using CR 8.5

Volume Invoice No
18.00 / N-017
4.00 / N-017
2.00
4.00
Total =28

How do i Sum Volume for Blank Invoice Number..So Sum Blank Value is 6

Thanks in Advance

Create a formula that returns the volume if the invoice is blank, 0 otherwise. This is Crystal syntax.

Code:

---

If {Invoice Field} = "" Then //may need to use IsNull depending on the data
  {Volume Field}
Else
  0

---

You can then use the typical Summary operations on the formula or create another formula with

Sum ({Formula Name},{Group Name})

Quote:

---

Originally Posted by brucevde

Create a formula that returns the volume if the invoice is blank, 0 otherwise. This is Crystal syntax.

Code:

---

If {Invoice Field} = "" Then //may need to use IsNull depending on the data
  {Volume Field}
Else
  0

---

You can then use the typical Summary operations on the formula or create another formula with

Sum ({Formula Name},{Group Name})

---

Thanks and thanks again Brucevde..It works fine...Thanks a lot :) :) :) :)

You're always great.im very appreciated it.