Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi All,
It's working now.
if(num($(vOppValue))>1000000,num($(vOppValue)/1000000,'£#,##0.00m'),num($(vOppValue)/1000,'£#,##0.00k'))
🙂
so what's your result now?
has your variable a = (equal) so the value is calculated?
Regards
Hi,
Thanks for your reply.
It won't calculate at all. It just returns a '-'.
Many thanks,
V
Apologies, yes, the variable calculates fine. It's a long calculation, that's why I opted to make it a variable.
Hi All,
It's working now.
if(num($(vOppValue))>1000000,num($(vOppValue)/1000000,'£#,##0.00m'),num($(vOppValue)/1000,'£#,##0.00k'))
🙂