The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 sum_* returns rounded values in row mode

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak Posted - 10/26/2022 : 03:56:52 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64

Greetings!

https://www.originlab.com/doc/en/LabTalk/ref/Sum-func tells:
quote:
In "row" mode
Returns a dataset of sums by row. Temporary datasets are also created to hold several related values generated by this syntax: _mean, _sd, _max, _min, _range, _npts.


However I discovered that _mean returns integer part of mean instead of mean. I assume that _sd, _max, _min, _range, _npts also deliver rounded values.

---
Andrey
6   L A T E S T    R E P L I E S    (Newest First)
AKazak Posted - 10/31/2022 : 01:31:02 AM
quote:
Originally posted by YimingChen

Can you share your workbook? I couldn't reproduce. Thank you.


James


Dear James,

Here you are:
https://my.originlab.com/ftp/forum_and_kbase/Images/sum_mean%202022-10-31.zip

---
Andrey
YimingChen Posted - 10/27/2022 : 09:56:33 AM
Can you share your workbook? I couldn't reproduce. Thank you.


James
AKazak Posted - 10/27/2022 : 06:01:15 AM
quote:
Originally posted by YimingChen

try this



SUM still delivers the rounded result with the suggested syntax.

Besides, I observe the same behavior with the following syntax:


---
Andrey
YimingChen Posted - 10/26/2022 : 3:59:11 PM
try this
AKazak Posted - 10/26/2022 : 3:24:08 PM
quote:
Originally posted by YimingChen

I couldn't reproduce the issue. Can you double check?


James


I use the following syntax:
sum(WorksheetNameorIndex, col1, col2);



---
Andrey
YimingChen Posted - 10/26/2022 : 11:38:10 AM
I couldn't reproduce the issue. Can you double check?


James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000