On Wednesday 10 October 2007 19:57:47 Drew Jensen wrote: > Howdy Ya'll, > > Paolo, there was a saying when I was growing up - The only way to learn > to swim is to jump in the pool. > Don't worry about making a splash, everyone here is already wet. :>) > > Paolo wrote: > > Hi Ariel, > > thanks for your answer. You've guessed my thoughts and now I feel more > > confident writing to the list. Hopefully this thread is not getting > > annoying for other users. > > > > Manuel: did you try and put some empty cells in the columns you're > > calculating? I get correct results if all of the cells do have a value > > (even zero) but I always get bad results when empty cells are around. So > > I need to set a default value of zero when I don't have any value for a > > given row. > > > :Ocke's email had two parts: First the formula line and second to make > > the default value for the formula the name of the field being summed. > > Doing this does yield correct results for a sub set of records that have > a mix of values and NULLS in the summarized field. ( It raises an error > if all the records in the group are NULL, but that is a different > issue and easily handled with the supplied error handling functions ) > > > So actually I have a solution for my problem, (place a zero in every > > empty value with zeroes) but I was still wondering if this behaviour was > > a feature or a bug in OO Base. > > > > This leads me to a new question... How do I keep all of these zeroes from > > printing? :-) (ok I promise I'll study for this...) > > > > Regards > > Paolo
Hi Drew, thanks for the support and for your advice. I'll try to use the wiki as well for a better communication in the community. About Ocke's function I've double-checked it and at least in my case il will behave the wrong way if you have a list of values with a few empty cells among them. The function will only sum the only uninterrupted group of "non-empty" cells. The NULLs seem to reset the count to zero (if this make any sense). I also get errors unpredictable in columns with non-NULL cells. Is something wrong with me? :-) I'll triple-cehck it anyway! Ok now let's take a look at the wiki :-) Regards -- Paolo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
