Move data if it includes negative values

Hi,

I want to see how I can move data over to blank coloumn called debit if they include negative values. So I have data that looks like the below. I was everything that is negative to move over to debit column on the same row.

Example:

Item Balance Debit

AB 709.09

CD 929.00

DS -312.01

SQ -2304.01

WS 201.00

Outcome

Item Balance Debit

AB 709.09

CD 929.00

DS -312.01

SQ -2304.01

WS 201.00

Gallery

Help

Accepted answers

cplewis90

Is your balance field a string or numeric field? A string field would not know how to interpret the <0 aspect of the formula.

If it is a string try:

if contains([Balance],"-") then [Balance] else [Debit] endif

bpatel

It may be because your field data types are not numeric. You can use the select tool to change the data types to doubles and that should solve the issue. Let me know if this works!

All comments

cplewis90

Hey @JamesG2806,

You should be able to use a formula tool to update the Debit column using the formula:

if [Balance] < 0 then [Balance] else [Debit] endif

JosephSerpis

Hi @JamesG2806 I have mocked a workflow that produces your output.

Negative_Values_Example.yxmd

JamesG2806

hey @cplewis90 thanks for the quick reply, unfortunately when I use this formula I get < is an invalid operator, Any ideas why ?

bennetml

I have the same scenario basically, but the acquisition (negative column) does not end in 0 once negative value is moved to retirement... Please help....

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703