+1Hi everyone,
I’ve created a balance sheet using BR and I want to remove the rows that has a balance of 0. Is there an option to do that inside Business Reporter?
Null valued rows like these should be hidden or removed.
This is the design
Appreciate your help.
+21Hello
In column design, you can try adding a filter criteria for Balance with does not equal operator.
Hope this helps
+1Hi
Thank you for your answer.
Yes I tried adding the filter but it does not work in this case.
+12Hi
As per my understanding the solution would be to have a filter option on the repeater (probably in the advanced settings) to surpress the 0’s. You can create a more advanced filter, like “balance_amount > 0 OR balance_amount < 0,” which means it will only show values that are greater or less than zero. This should work to exclude the zeros.
If this response helps you, please mark it as the correct answer, as it will also assist other community members in future.
Regards
Chanuka
+21Hello
I tested and it works. You must do the same for all columns has a design.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
