Assign node and calculation

Hi,

I have a lawson query where I pull amounts and try to add them in the assign node inside teh query loop. The total after the loop shows all values as appended and not added. The similar calculation for the record count works. The total variable is declared in the Start node as double.

I could not find a similar case that would help me.

Thank you!

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

jreese

The query is probably treating the queried value as text and not a number. Try converting the queried value to a number value * 1 before adding it to the previous total.

john-miller

Use the Javascript Editor to translate the SQL_FIELDVALUE from a text to a number:

Variable = parseInt(SQL_FIELDVALUE); if you expect an Integer,

Variable = parseFloat(SQL_FIELDVALUE); if you expect decimals.

All comments

jreese

The query is probably treating the queried value as text and not a number. Try converting the queried value to a number value * 1 before adding it to the previous total.

john-miller

marija-dosan

Thank you - that worked!

marija-dosan

Thank you - this works as well!

Copyright © 2025 Infor. All rights reserved.