[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
Re: How do I Sum Blank Value
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})
Re: How do I Sum Blank Value
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.