CHANGING THE SIGN OF THE NUMBER

Question

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/CAmountExpected AmountD100100C100-100D5050C50-50

Emil_Kos · Answer

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.

-1.yxmd