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
On Wednesday 10 October 2007 01:44:54 Ariel Constenla-Haile wrote:
Hi Paolo,
Paolo escribió:
Now I promise to be good and study my functions in the .jar archive
before bedtime. I don't know if it will help, as my programming skills
are... well... zero? ;-)
Just one more question: is this mailing list the right place for this
kind of discussion? I don't want to be considered an "intruder"
Thanks to all the nice persons around for your help so far.
Everything you can ask, even those questions you may think that are too
"stupid", or too "childish" (does this word exists?), or may even give
you shame to ask - ALL these is welcome and can, now or in the future,
help someone in the same situation as you're now - at least from *my*
point of view: we all were absolute beginners, and nobody is born
spelling C++.
So don't feel like a foreigner here - what concerns me, you can feel
like home!
Bye and luck!
Ariel.
Mailing lists are wonderful things, but they are not the only tool
available. Paolo, Arial there is the wiki, it is free, open, available
and wonderfully suited to capturing what you guys are doing in a way
that can be easily reused by those that follow. By doing this on the
mailing list the information falls below the radar screen very quickly,
search engines not withstanding, and since OO.org mailing lists are not
indexed by the major search engines this is a problem.
Please consider moving this conversation to the wiki.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
