Skip to Content
0
Former Member
Mar 25, 2015 at 10:39 AM

Dynamic column handling in reports of BPC 10.0 NW EPM Add in

47 Views

Hello All,

My requirement is to have 3 columns. Col1 is defined based on Context selection from TIME dimension . Col2 is defined based on EPMoffset function based on Col1. Col3 to be shown always previous year with Dec month (2014.12). Say for Example : if current context is 2015.03 , then Col3 should populate value for 2014.12.

I am having problem in calculation of Col3 . please can someone share the inputs on this calculation.


Thanks!

Veer

Attachments

Pic1.png (12.1 kB)