cancel
Showing results for 
Search instead for 
Did you mean: 

Is is possible to do quick sum up/average by selecting specific cells in SAP IBP Planner Workspace?

contovhal
Explorer
0 Kudos
311

I would like to see sum up or average value of couple of cells selected, similar to Excel functionality, so, let's say if I have 100pcs in June and 30pcs in February - by selecting two months I would like to see 130 pcs calculated and displayed on the fly, not the whole KF total. Is it possible in web interface - Planner Workspace?

Thank you!

Accepted Solutions (0)

Answers (2)

Answers (2)

Andrei_Lupu
Participant
0 Kudos

Yes, you can add a "formula" , which is sort of a Key Figure created on the fly. 

Please see below further details https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/abee3923ad4d4722b6f10b0fe6cf4cef/5603412f...

contovhal
Explorer
0 Kudos
Thanx. but that is not really an expectation. because on the fly I am flexible with choosing quickly different number of periods or Kf's
vincentverheyen
Active Participant
0 Kudos

Hi @contovhal,

No, as far as I am aware, this is currently impossible in "Planner Workspaces".
Easiest would be to CTRL+C, CTRL+V it into MS Excel, and that will give you the Sum immediately.

Kind regards,

Vincent Verheyen