Skip to Content
0
May 27, 2020 at 01:38 PM

How to restrict 100% value in "Total"Column in SAP IBP

101 Views

total-column.jpgepm.jpgHi All

There is a user key figure where the user would input % across months. Requirement is to ensure the summation from all the months is exact 100%. Meaning the Total column should not be more 100%.

I tried to define it via EPM total member format (attached screenshot), but its not working. it works for the individual cells of that key figure but not on the total Column.

Would like to avoid the VBA option, any idea's that how it can be done via EPM formatting?

Thanks, Aswath

Attachments

total-column.jpg (77.0 kB)
epm.jpg (135.1 kB)