Create new column with negative and positive amounts

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have excel files with example like below:

I need to identify the negative (D) amounts in able to create correct Running Balance in my application.

My idea is to create a new column to create a running balance the will show me the running balance so i can identify the correct MAX and MIN.

Re: Create new column with negative and positive amounts

marcus_sommer — Wed, 13 Dec 2017 16:27:28 GMT

Just create a flag within the load with something:

if(Type = 'D', -1, 1) as Flag

and then you could multiply with it in the expresions, for example:

sum(Amount * Flag) // within the Balance expression

- Marcus