CHANGING THE SIGN OF THE NUMBER

[dunkindonut7777]

Hi I would just like to ask if how can I change the sign using the debit/credit indicator fields. I want to know the exact formula to use so that its easy for me to transform. I want to change the sign with negative (-) if it is "C". Here is the sample data:

D/C	Amount	Expected Amount
D	100	100
C	100	-100
D	50	50
C	50	-50

[Emil_Kos]

Hi @dunkindonut7777,

This is relatively simple. You need to use the formula tool and use this formula:

IIF([D/C]='C', [Amount]*-1, [Amount])

We will just multiply your value by -1 to get the expected outcome.