#NODATA error is coming in EVPRO after upgrading SP08 to SP18

[former_member280858]

Hi Experts,

We have upgraded from SAP BPC 7.5 NW SP08 to BPC 7.5 NW sp18. After upgrading when we refresh reports we are facing #NODATA error where ever there is no id against to EVPRO formula.

We were not facing this issue before upgrade, SP08 reports are working fine.

I am attaching the screen shot of SP18 and SP08 for your reference.

Thanks for your inputs to resolve the issue.

Regards,

Raj

9901588009

[Former Member · Accepted solution]

Hi Raj,

just delete the formulas in those cells?

or add a IFERROR check in them.

Andy

[former_member186338 · Accepted solution]

IFERROR will not help - it's checking for Excel errors.

Better:

=IF(EVPRO(...)="#NODATA","",EVPRO(...))

or

=IF(A10="","",EVPRO(...)) where A10 - member ID cell

[former_member280858 · Accepted solution]

Thanks vadim for your support..

[former_member186338]

Formulas in both cases?

[former_member280858]

Hi Vadim,

I am sorry i didn't get you, what you mean by both cases.

Regards,

Raj

[former_member186338]

Sample:

or:

=IF(B5="";"";EVPRO("INFILE";B5;"PLANBE"))

Is it clear?