Hello Expert,
I have a requirement of dividing certain values by 100000, For this I have used various types of formulas and number format but it is not working out.
So after making certain research I came with a conclusion that we can achieve the same by writing a VB Code in a BPC Workbook via Macros, So I Wrote the same and here is the example of my code.
Sub Workbook_RefreshAll()
ActiveWorkbook.RefreshAll
'
'
Range("D117").Value = Range("D117").Value / 100000
End Sub
Basically I want the value in cell D117 on one worksheet to be divided by 100000, I am getting these properly but when I refresh again by going to EPM Tab above the calculated value derived by VB Code disappear and I am getting value which is not divided by 100000.
Below attached is the screen from where I am refreshing my BPC Workbook.
Please let me know in-case of any other solution on these or if I am missing out any steps.
Appreciate your efforts in advance.
Thanks & Regards,
Foram