Showing results for 
Search instead for 
Did you mean: 

Showing data in 'Ones' , 'Thousands' & 'Millions'

Former Member
0 Kudos

Dear BPC Experts,

I am designing a report in BPC 10 NW and in this client want the choice of showing the revenue number in 'Ones', ' Thousands' & 'Millions'.

I tried conditonal formatting and created three ruls for one, thousand and million. But this approach only accept one rule.

Kindly advice if there is any EPM function to  meet this requiremtnt OR how can I create a drop down with three option (i.e Ones, Thousands. & Million) and client select anyone and refresh the report and  the data format is changed accourdingly.

Kind Regards,


View Entire Topic
0 Kudos

did you fix the issue with scaling the data in thousands, millions, or ones?

do you want to do it using epm functions or via after refresh in VBA?

let me know