How to Split Debit and Credit Amounts in Bold BI?
In some cases, you may need to separate debit and credit amounts in your data for better analysis and visualization. This article will guide you on how to create separate expressions for splitting debit and credit amounts using Bold BI.
Expressions for Splitting Debit and Credit Amounts
To split debit and credit amounts, you can use the following expressions:
Credit
IF(SIGN([Amount]) = 1 , [Amount],0)
This expression checks if the value of the “Amount” field is positive (i.e., a credit amount). If it is, the expression returns the value; otherwise, it returns 0.
Replace your column name in Amount.
Debit
IF(SIGN([Amount]) = -1 , [Amount],0)
This expression checks if the value of the “Amount” field is negative (i.e., a debit amount). If it is, the expression returns the value; otherwise, it returns 0.
Replace your column name in Amount.
**Note: ** This is applicable for all the data sources in Bold BI.
Example
Refer the example image below
Related Links
