Skip to Content
0
Former Member
Aug 03, 2016 at 10:01 AM

EPM 10 VB Code for deriving values after division

43 Views

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

Attachments

Refresh report.PNG (60.8 kB)