Show empty value in BPC report for specific member

[Former Member]

Hi People,

Below is my sample report, and want to cells to display no values for account 400001002 even though it has values in it?

Using EPm Formatting sheet? Please advice .

Thanks,

Vishu

[former_member186338 · Accepted solution]

Strange requirements... What for?

[Former Member · Accepted solution]

Hi Vadim,

I just came to know my mind, is it possible to do in BPC reports using EPM Formatting sheet or using any other option . It is just curiosity.

Thanks,

Vishu

[Former Member · Accepted solution]

Hi Vishu,

Yes we can...Through formatting sheet as below...

Regards,

JP

[Former Member · Accepted solution]

Hi JP,

Could you please write formula as i am not able to see complete formula in above shared picture.

Thanks,

Vishu

[Former Member · Accepted solution]

In the Content Override window write as ="" and then click on "Override"

JP

[Former Member · Accepted solution]

Hi JP,

I have written All | (Content = "") but it showing "" like this in out put cells for that specific account.

If i use formula like All | (Content = 0) then out put cell has 0.

What shall i write if i want empty value?

Thanks,

Vishu

[Former Member · Accepted solution]

Vishu,

It should be double = =. can you see my screenshot?

Regards,
JP

[former_member186338 · Accepted solution]

You can also format text color as white - same as background color. But in general I don't think it's a good idea!

[Former Member · Accepted solution]

Ok JP.

I used formula like this ALL | (Content = ="").

Cell has empty by looking  but if i put cursor on cell it has ="". Please see below SS.

thanks,

Vishu

[Former Member · Accepted solution]

Ok...You can hide the formula as well....Go to the Hidden parameter by double clicking and in the Override Just write True, and make sure you lock the cell and the Worksheet from the Sheet option then only the option will work.

[Former Member · Accepted solution]

Thanks JP.

It works well.