SAP BFC 10.1 Display Rows with "0" data

[former_member1013523]

Hi All,

I have to modify a schedule where i want to display all the rows, included the lines with the data 0. I looked everywhere (User Guide / Q&A,...) and didn't find how to do it.

Do you have any idea how to do it ?

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[Olga_Vasileva · Accepted solution]

Hello dracontias ,

Have you tried to use expansion property? On your screenshot it's purple, and if set to expand it should be blue.

Please see User Guide for more information: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_FINANCIAL_CONSOLIDATION/b9d07a1932014658b7ac8268c5c2b4...

[former_member1013523 · Accepted solution]

Hello and thanks for your help.

Yes, I already tried to modify this option but no change visible.

[Olga_Vasileva · Accepted solution]

Hello dracontias , just in case - have you also remembered to enable the setting: Action > Active Expansion > Analysis?

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_FINANCIAL_CONSOLIDATION/b9d07a1932014658b7ac8268c5c2b4...

[adelaide_brunel]

Thanks. By default, 0 should be displayed if you have any in your consolidated data.
You can check if you have specific cell format or formula. If not, please open an incident so we can have a deeper look.
Regards

[former_member1013523]

I think there is no data in my consolidation in some rows. So is it possible to displays rows without any data ?

[adelaide_brunel]

Hi,

Can you please show us how is configured your report ?
You should have the expected result using the expansion option in the report (right click on the row / column).
Regards

[former_member1013523]

Thanks for your answer. I don't know which part exactly you want to see :

[adelaide_brunel]

Thanks. Can you show the selection part and if you use the expansion option ?
Regards

[former_member1013523]

Is it this part you are talking about ?

[former_member1013523]

Yes !!! It worked, thanks a lot !!!