Convert DT Row Item to Negative Value

Help Studio
1

Hello,

I could use some help converting a positive value to a negative number.

This is part of a workflow that reads an excel sheet then loops through the data to make various changes. One update I need is for the amount in Column2 converted to a negative number.
Within my for each row activity I believe I will need to use an assign activity, just not sure what I need to wrap around my Row.Item(“Column2”) in order to make the value negative.

2

Hi,

If your value is integer, the following will work.

Row.Item("Column2") = CInt(Row.Item("Column2").toString())*(-1)

If your value is double, can you try the following?

Row.Item("Column2")  = Cdbl(Row.Item("Column2").toString())*(-1)

Regards,

1 Like
3

Awesome, thank you. My value was a decimal so I changed it to Cdec and it worked perfectly. :slight_smile:

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.