[RESOLVED] How do I Sum Blank Value

[girl81]

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

[brucevde]

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

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})

[girl81]

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

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.