WhiteUnicorn

	#WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >

Frequently Asked Questions

A sum(if(...,...,0)) always returns 0

Question:

The following expression always returns 0: Sum(if(Query1.CartonID = 'SI', Query1.Caliper, 0)) Why?

Answer:

Change the 0 to 0.0 and the Sum function will work 

as expected.

	#WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >

	Anastasija aka WhiteUnicorn	LiveJournal PhotoFile