Small and medium business | Business Central, N...

hide all Zero Amount Accounts in Analysis View Matrix

(0) Share

Report

Posted on by sami khan

Hi all,

I have created an Analysis View with respect to Dimensions. I have hundreds of Accounts in my GL Account list. But only 15-20 GL Account Entries. Issue is that Analysis View Matrix shows all accounts with zero or GL Entry sums. How can I hide or filter Zero Values from Matrix. Any suggestion to right direction will help. I am open to AL code as well.

Regards

All responses (2)

Answers (0)

sami khan 45 on at

Like (0)

Report

RE: hide all Zero Amount Accounts in Analysis View Matrix

Hi Jyotsna. Thanks for the quick response.

I have specific requirement to do this in Analysis View. We cannot move to RDLC because we neither view specific entries on clicking nor we can toggle in the treeview as they are shown as pdf in Business Central.
Suggested answer

Jyotsna NAV 585 on at

Like (0)

Report

RE: hide all Zero Amount Accounts in Analysis View Matrix

You can achieve that in the RDLC report using the Column and Row Visibility Property on Columns and Rows respectively.

For example: Right-click on a row > Row Visibility > Select 'Sjow or Hide based on an expression' > Write expression =iif(Your_Amount_Field=0,true,false) > OK

Regards
Jyotsna
jyotsnanav.blogspot.com

Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.