Why =SUM... WRONG ! [see:upLd]
Mon, 25 Apr 2016 - 9:02 AM
For rapid chk; Look col.E…B
—————————
Opps, I assumed you could ATTCH. FILE … but, HOW?
… Found ATTACHMNTS … but, will not upload file ?
Tue, 26 Apr 2016 - 6:08 AM
#2
Oweng ...
Thank you for responding!
Strange that .ods files are not accepted … especially when
they are listed as permissible.
The other issue SIZE … file: 12kb, allowable: 8Mb
So WHATZ’UP?
Tue, 26 Apr 2016 - 10:14 AM
#3
A possible answer ...
file must be Saved, [which it wasn’t] …
BINGO ! it worked.
| Attachment | Size |
|---|---|
| IHSS_eM-SUMbad.ods | 11.04 KB |
Tue, 26 Apr 2016 - 10:52 AM
#4
It's a matter of inadequate number formats.
See attached.
========
Editing, BTW
In the attached file I statded “…unfortunately such time values will again be truncated instead of rounded as is standard for numeric values otherwise.” As I just tested this seems to be fixed in V5.1.2 for the [SS] format. It’s still the old way regarding the [MM]and the [HH] format. Even more a mess?
| Attachment | Size |
|---|---|
| lof13273_NothingBadExceptFormats001.ods | 17.7 KB |
Tue, 26 Apr 2016 - 12:17 PM
#5
Lupp ...
Thank you, as always.
The issue turned out to be;
trying to Sum, and the values were in hh:ss frmt.
After CONVERTING the vals-> Decimal … the sums agreed.
Tue, 26 Apr 2016 - 12:49 PM
#6
If there is not a reason...
…to use a time format, we shouldn’t do, of course. If we process values actually meaning time we will want to also get them shown in an adapted format. The values themselves never are in a format. What we get shown is due to formats. The format does not affect the calculations anyway. Only the results may be displayed in a misleading way. This was the problem with your example.
Attachbutton. Only certain file types are allowed (a message will display indicating the type list if the filetype is unsupported).