2 Replies Latest reply on Jul 6, 2018 7:22 AM by Robert Angel

Hide column based on no data in another column - financial reporting web studio

Teresa Modesta Jul 6, 2018 7:15 AM

PBCS / Financial Reporting Web Studio

I have a column in a report which is populated by Year / Scenario / Period - with year and scenario driven by variables which are not the same as all other columns in the report.

When the column has no content I want to suppress.

Okay - easy - using - Column Properties / Suppression / If Missing Suppress - right?

But the bit I am struggling with is this column has two other calculated columns associated with it, Variance £, Variance %; and I want to suppress these when the main column is hidden.

Any way to do this please?

Column A - always populated

Column B (&Repyear, &RepScenario, &RepMonth)

Column C = Column A - Column B

Column D = Column C / Column A as a %

So Column B has Basic Option 'If Missing Suppress'

How to make Column C / D disappear if Column B is suppressed??

1. Re: Hide column based on no data in another column - financial reporting web studio

Robert Angel Jul 6, 2018 7:22 AM (in response to Teresa Modesta)

In the same Suppression options,

1. Tick Advanced options

Yes?
Like Show 0 Likes(0)

Actions
2. Re: Hide column based on no data in another column - financial reporting web studio

Teresa Modesta Jul 6, 2018 7:29 AM (in response to Robert Angel)

Yes, yes, YES!!!

Thank you!!!!

Took a bit of fiddling with because my scenario was actually slightly more complex than I described, but yes, this works.

I had looked for this but did not expect it to be under the = options - think it is because I am a bit of a sql head and still have it in mind that nothing is ever equal to null - and yes - I know it is different in Essbase...
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.