Surpressing local member column when there is zeroes

[former_member481715]

Hello I have few columns in the report that have some excel formulas. My requirement is when there is no data , in other words, zeroes in those column values, it should just be hidden. Any suggestions?thanks.    

[Former Member · Accepted solution]

Hi Manny,

If you are using BPC 10 then

EPM>Options>General>Rows>Hide Empty or Zero Values

Regards,

Kalyan.

[former_member199935]

have you checked EPM sheet options "No Data and Zero values settings" that has an option to select "hide columns". But, this requires the formulae column to be "local member formula".

if this is purely excel formula column and not "local member formula", only option i see is to use VB macro that runs after "EPM refresh".