Hi Experts,
I have a requirement for writing a formula in IP as follows..
I need to calculate my pyextrasales(Of my store) as per the below formula
pyextrasales(of my store) = pysales(of my store)/pyweeksoperated of my store * cyweeks operated by my store
Here pyextrasales,pysales and pyweeks operated by my store is from my actual cube.
cyweeks operated by my store is from my planned cube.
Please help me in this planning function.
Thanks in advance,
Pushpa M.