cancel
Showing results for 
Search instead for 
Did you mean: 

Native Excel formulas in BPC Reports and IS

0 Kudos

Hi Gurus,

I am working on BPC 7.5 NW version , when creating IS and Reports i am using excel formulas , but they are disappearing when expand all. Can anyone give me idea how to include native excel formulas and use.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186498
Active Contributor
0 Kudos

Hi Ravi,

you must check that your formula is outside of the expansion range area, if not the formula will disappear after expand / refresh.

To correct the issue just change the expansion range excluding the column with the formula (you must have a minimum of 2 cols left and right of the formula), remember that you can write the formula just on the first row it will be automatically expanded, or you can transform your input sched in a static template.

Kind regards

     Roberto

0 Kudos

Hi Roberto,

Thanks, it is working but how can i insert a new col in between the range and how to define multiple EVRANG IN colkeyrange. the formula which i written in first row doesn't expanding automatically , can you tell me how i define to get it automatically.

Regards

Kishore

Former Member
0 Kudos

Hi Ravi,

If u r using a dynamic template and if u remove your column from expansion and if u write any formula in your first row it expands automatically to rest of the row.

u can define multiple col range in collkey range by comma separation.

Regards

Radhika m

Answers (0)