Re: [O] Suggested change to Manual 3.5.9 example table

[Nick Dokos]

Charles <address@hidden> wrote:

> I have searched the news groups concerning this and found nothing.
> 
> I am attempting to learn the advance features for tables and could not
> understand 29.7 as the result for $at=vmean(@address@hidden);%.1f.
> 
> I copied the table and formulas into a scratch org file, changed the
> floating point to .2f and the result was 25.00, which I believe is
> correct. I changed it back to .1f and 25.0 was the result.
> 
> Is the result as given in the manual supposed to demonstrate some
> concept that is not evident to me?
> 

Good one.

It *may* have been intended to illustrate the difference between rows
marked with # and unmarked rows; e.g. if you go back and change a grade
in Sam's row and press TAB, then the # rows are recalculated but the
unmarked one is not.  So the 29.7 might have been a (now incorrect)
remnant of a previous calculation that would have been corrected in the
next global recalculation.

However, if that's the case, a more extensive explanation would
certainly be welcome.

Nick