Hi 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.
Hello
In column design, you can try adding a filter criteria for Balance with does not equal operator.
Hope this helps
Hi
Thank you for your answer.
Yes I tried adding the filter but it does not work in this case.
Hi
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
Hello
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.