Hi all,
I am working on creating a DataFlow as I needed to format a column from text to a date. During this process, it changed 'Net Change USD' from a Fixed Decimal to an Integer if I don't alter the column. I have altered the column to show 'Net Change USD' as a fixed decimal but it changed to just a decimal with the values still getting dropped (screenshot attached). Below is a screenshot of the column from the input and then output dataset. I also attached a screenshot of my dataflow including the formula I use for a different column incase that is causing the issue. I don't touch Net Change USD anywhere else, so I am not sure why the fixed decimal values are not carrying over.