diff --git a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
index db984e821a59aaddd41cea582dcbdb8bf6dab5f1..084ea9b80ea2d5fab7f25a49ae43324041d1e4a0 100644
--- a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
+++ b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
@@ -179,7 +179,7 @@ def accumulate_values_into_parents(accounts, accounts_by_name, dimension_list):
 def get_condition(dimension):
 	conditions = []
 
-	conditions.append(f"{frappe.scrub(dimension)} in %(dimensions)s")
+	conditions.append(f"{frappe.scrub(dimension)} in (%(dimensions)s)")
 
 	return " and {}".format(" and ".join(conditions)) if conditions else ""