Dynamically formatting a KPI using a variable

[vmcintyre]

Hi All, 

I have a series of KPIs that need to be displayed in £s and either have 'k' or 'm' after them depending on their value, so I need the formatting to be dynamic. 

I've been using the following:

=if($(vOppValue)>1000000, num($(vOppValue)/1000000, '£#,##0.00m'), num($(vOppValue)/1000,'£#,##0.00k')

I'm unable to share my app, as it has client data. 

Many thanks, 

V

[martinpohl]

so what's your result now?

has your variable a = (equal) so the value is calculated?

Regards

[vmcintyre]

Hi, 

Thanks for your reply. 

It won't calculate at all. It just returns a '-'.

Many thanks, 

V

[vmcintyre]

Apologies, yes, the variable calculates fine. It's a long calculation, that's why I opted to make it a variable. 

[vmcintyre · Accepted solution]

Hi All, 

It's working now. 

if(num($(vOppValue))>1000000,num($(vOppValue)/1000000,'£#,##0.00m'),num($(vOppValue)/1000,'£#,##0.00k'))

🙂