Functions do not work when a variable is missing
Posted: Wed Jul 21, 2021 6:21 pm
I am trying to get the sum of 6 variables but the SUM() function does not return anything when any of the columns contain a missing value.
On one of the images on the documentation, I saw that it was the same for the MEAN() function.
It is OK if it was working this way by skipping the missing values for VMEAN(), but why can't get the MEAN() when one of the vars is missing?
Considering that Jamovi uses a "dynamic spreadsheet", I expect it to run user added functions as any spreadsheet app would.
I am using version 2.0.
Is there a workaround of this issue, except exporting the data and edit it in another spreadsheet app?
On one of the images on the documentation, I saw that it was the same for the MEAN() function.
It is OK if it was working this way by skipping the missing values for VMEAN(), but why can't get the MEAN() when one of the vars is missing?
Considering that Jamovi uses a "dynamic spreadsheet", I expect it to run user added functions as any spreadsheet app would.
I am using version 2.0.
Is there a workaround of this issue, except exporting the data and edit it in another spreadsheet app?