Error in Formula: ')' after function expected

[Kai Zhang]

Dear all,

 

I am a beginning user of Statistica 13.5.0.17.

I was following the tutorial on (https://community.spotfire.com/wiki/primer-bi-and-iotiiot-and-edge-analytic...) When trying to run the workspace which has been shared as example in the tutorial an error appears in the 'Transformations of Variables' node.

 

"Error in formula: ')' after function expected"

 

However I haven't modifief the expression and it seems also correct by me, I have tried to search documentation and forum Q&A but cannot find the solution to this error.

 

Can anyone elaborate on this issue Kind regards,

[Gaia Paolini]

Hi

 

I have downloaded the zip file and both RegressionPrediction and ClassificationPrediction protocols ran OK for me. Can you post the expression that does not work for you Which workflow

 

Gaia

[Kai Zhang]

Hi Gaia,

 

Thanks for the fast reply. Both the Regression and Classification don't work.

The expressions is:

 

FlameTemperatureLagged=lag("Flame temperature (F)",-10)

 

 

I didn't modify this expression, so it could have something to do with the way this version 13.5.0.17 compiles this expression I added a screenshot in attachment.

 

Thanks in advance

Kind regards,

[Gaia Paolini]

Hi

I have exactly the same version of Statistica.

It might be due to the local formatting of numbers and separators. I see the formula with a comma separator of the arguments, before the -10, as you do:

FlameTemperatureLagged=lag("Flame temperature (F)",-10)

my colleagues in continental Europe see it like this with a semicolon:

FlameTemperatureLagged=lag("Flame temperature (F)";-10)

If I try to change mine to a semicolon I get the same error as you.

Could you try changing the comma to a semicolon

Gaia

[Kai Zhang]

Hi Gaia,

 

 

 

Could be indeed something with the local number formatting. Unfortunately changing to a semicolon gives the same error. Is there somewhere else (option panel) where I can change this formatting

 

 

 

KR

[Gaia Paolini]

could you tell me what locale you are on Maybe I can reproduce your problem this way.

 

e.g. look in

 

control panel > region 

 

check format and additional settings for numbers (like decimal symbol, list separator...)

 

Maybe post a snapshot

 

Gaia

[Kai Zhang]

Hi Gaia,

 

 

 

Ok, no problem. Here are the screenshots (added to the original question post)

 

 

 

KR Kai

[Gaia Paolini]

Thanks. I see that your list separator is comma (,). When I set my region to the same as yours, my list separator becomes semicolon (;) so my expression appears with a semicolon and it works. When I change the list separator to comma, it gives the error. So if you go and change your list separator to semicolon in the control panel, it should work. Strange, I would have thought that using a comma both for the decimal and list separator would not normally happen. Gaia

[Kai Zhang]

Hi Gaia,

 

 

 

You are right if I change the list separator to a semicolon, then indeed it works. We usually prefer to use the comma separator for exporting excel to a comma separated file CSV, instead of a semicolon separated one. But indeed, if that is the issue here, than I will need to switch between the comma and semicolumn. I would have hoped that I could change this setting within statistica

 

Thanks a lot for solving the issue!

 

Kind regards,

 

Kai

[Gaia Paolini]

maybe an alternative solution would be to change the decimal separator to dot instead But great that at least there is one solution.