Skip to Content
0
Dec 14, 2018 at 12:31 AM

How to Lock Cells on Local Member Formulas

263 Views

Hello,

I'm trying to lock local member formulas cells. Right now I can lock them but when I change the time dimension in the context and refresh the report they become "unprotected" again.

The formulas I'm using are as followed:

=IFERROR(EPMComparison("finance", EPMMemberID(E33), F33, G33), 0)

=IF(E29="Check Sum", "", IF(ABS(G29)>1, IFERROR(H29/ABS(G29), 0), 0))

I was reading online it has to do with the iferror function, but was wondering if I can get them to lock anyways with them through epmformatting sheet.

Thanks,

Will

Attachments

capture.jpg (36.4 kB)