Hello comunnity. Maybe someone can help me on this:
I have 2 numeric columns (Debit and Credit). I have formated both for currency, including a Plus sign or a Minus sign.
When I use a If-then-else column to display one of them, the Data Editor looses the formating.
In those cases I usually create a template column filled with the value from a numeric or math or date column to “lock in” the formatting. Then you can use the template column in the IF/THEN and the value will stick. In your case you may be able to shortcut this. Create a template column and fill it with the letters ‘CD’. Set the replacement value of C to the credit column and the replacement value of D to the debit column. This might work without the need of an If Then column.
That’s debatable I guess. In most cases, yes I’d prefer if we didn’t have to do the template trick, but I can also understand if you have a situation where you would want to show the result of each step of a complex calculation, but only display a rounded or formatted value on the screen. Take pi for example. You might want to only display 3.14, but your calculations still need to use 3.14159265359. I think 3.14 is easier on the eyes if you are displaying it on the screen
I can see it both ways, but I’m glad I at least have the option to either use a template as a workaround or not.