Expression - If column has text adjust value column to the right

[jalizmaldonado]

Hi, I'm trying to move my value column to mirror the text column.

For instance, if there's text in the G/L CATEGORIES (DR) column keep G/L CATEGORIES (DR) value data in the G/L CATEGORIES (DR) data column but if there's text in the G/L CATEGORIES (CR) column then value from G/L CATEGORIES (DR) value column to the G/L CATEGORIES (CR) value column.

Tried using the multirow tool with the following formula but it did not work out for me:

if !isnull([G/L Categories (DR)]) And isnull([G/L Categories (CR)]) then
[[Row+1:Value]+1]]
else
[[Row-1:Value]]
endif

[pedrodrfaria]

Hi @jalizmaldonado 

I'm not 100% sure I follow why you are using a multirow based on your explanation. Are we trying to look at different rows and bring those values? or are we trying to create new columns based on the same row information?

Based on what you described, this would be the set up creating new columns:

DR

if !IsNull([G/L CATEGORIES (DR)]) and IsNull([G/L CATEGORIES (CR)]) then [G/L CATEGORIES (DR)] else Null() endif

CR

if !IsNull([G/L CATEGORIES (CR)]) and !IsNull([G/L CATEGORIES (DR)]) then [G/L CATEGORIES (DR)] else [G/L CATEGORIES (CR)] endif

Let me know if this was not what you were looking for.

I attached the workflow.

[jalizmaldonado]

Hi @pedrodrfaria

I'm trying to move the numerical value in the place of the debit/credit text so that it creates a balance sheet. 

[echuong1 · Accepted solution]

If I understand your requirements, this should work:

I first used a formula to fill in the CR values - if the category for CR is not null, then I took the value from the DR column.

I then used another formula to clean up the DR values - if the category for DR is not null, I kept the value as is. Otherwise, I replaced it with a null.