on 07-03-2012 4:41 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.