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 |
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.