cancel
Showing results for 
Search instead for 
Did you mean: 

Using excel formula in epmformattingsheet

Former Member
0 Kudos

Hi all,

I've been using the method in link below to populate a column in my report - by entering the formula in the formatting sheet for a specific member.

However, when the value in the cells change based on the formula, EPM doesn't seem to recognize the change to the member values. It keeps saying there is no data to save even if the values have been modified.

The report is setup as an input report - doesn't inherit sheet options and the members are not set as read-only members. The members are base level too.

Could anyone help?

Thanks

Mala

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Mala,

I don't have any issues with this approach, if the values are changed then send data works correctly.

Test on some simple input form.

B.R. Vadim