topic Re: Dynamically formatting a KPI using a variable in App Development

Dynamically formatting a KPI using a variable

vmcintyre — Mon, 07 Oct 2019 08:58:09 GMT

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,

Re: Dynamically formatting a KPI using a variable

martinpohl — Mon, 07 Oct 2019 09:06:11 GMT

so what's your result now?

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

Regards

Re: Dynamically formatting a KPI using a variable

vmcintyre — Mon, 07 Oct 2019 09:09:53 GMT

Hi,

Thanks for your reply.

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

Many thanks,

Re: Dynamically formatting a KPI using a variable

vmcintyre — Mon, 07 Oct 2019 09:21:39 GMT

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

Re: Dynamically formatting a KPI using a variable

vmcintyre — Mon, 07 Oct 2019 09:50:53 GMT

Hi All,

It's working now.

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

🙂