Skip to Content
avatar image
Former Member

EPMReportOptions work for hiding columns (hiding empty and zero values)

Hello

can someone help me Remove empty and zero values for columns. I want to create a formula that hides empty and zero values from columns (done by selecting it from a dropdown). I am currently using the formula:

=IF($B$25=$E$1,EPMReportOptions("000","KeepEmptyColumns =HideEmptyandZero"),EPMReportOptions("000","KeepEmptyColumns =true"))

However it is showing an error "String was not recognized as a valid Boolean." If I replace Hide with Remove, it works perfectly. It seems this function is catered only to remove and not to hide.

Could someone explain why this works for Remove columns but not Hide?

Thank you! Dru

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 14, 2017 at 04:02 PM

    EPM version?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2017 at 04:13 PM

    By the way, the syntax is incorrect! Result: "String was not recognized as a valid Boolean."

    Please copy syntax from help:

    "KeepEmptyColumns =RemoveEmptyandZero"

    P.S. Just tested with formula:

    =EPMReportOptions("000","KeepEmptyColumns =RemoveEmptyandZero")

    Working correctly!

    P.P.S

    "Could someone explain why this works for Remove columns but not Hide?" - Because it's documented to work only for Remove!

    Add comment
    10|10000 characters needed characters exceeded