topic Python expression in Modelbuilder in ModelBuilder Questions

Python expression in Modelbuilder

TereziaBecker — Wed, 09 Oct 2019 07:34:12 GMT

Hi,

I need to sum two fields which are in different layers...

Using Calculate field and running the expression sum(%Summe_Trassen_eigen%,%Summe_Trassen_angemietet%)

I get incorrect value.

sum(%Summe_Trassen_eigen%,%Summe_Trassen_angemietet%)

The example is: "sum([582,871017020542,2826,20859771853])

the result is: 891876795803 - whats wrong, it has to be 3409,0796...

can you advice whats wrong?

thanks

Re: Python expression in Modelbuilder

NeilAyres — Wed, 09 Oct 2019 09:00:53 GMT

You appear to have your decimal delimiter (radix) set to a comma ",".

So:

582 +

871017020542 +

2826 +

20859771853

= 891876795803

So change it back to ".", a decimal point.

Re: Python expression in Modelbuilder

TereziaBecker — Wed, 09 Oct 2019 09:54:51 GMT

Hi @Neil Ayres,

thanks for answer.

The problem is that I get this values from summstatistic (values are "double"). So it gives me automatic "comma" values. Is there a way how to change double to integer or how to change it to a decimal point?

"Summstatistic" > (the fields are double) > "Get field value" > (double, with comma) - *I do not need the values behind the comma

Re: Python expression in Modelbuilder

NeilAyres — Thu, 10 Oct 2019 09:07:21 GMT

Changing the decimal symbol is buried quite deeply in the Time & Date setting of Windows.

Re: Python expression in Modelbuilder

NeilAyres — Thu, 10 Oct 2019 09:38:04 GMT

Sorry, those dialogs are under "Region"

Re: Python expression in Modelbuilder

TereziaBecker — Thu, 10 Oct 2019 09:52:39 GMT

Great thanks a lot!