topic Re: Num Format in App Development

Num Format

manoranjan_321988 — Sat, 16 Nov 2024 20:32:15 GMT

Hi all,

Below expression is not working in the line chart

if(MetricId=1,
(sum([Gross Sales])/1000000)&'M',if(MetricId=2,num((sum(Units)/sum([Target Units])),'#.##%')))

pls suggest.

How to achieve this

if user select metric id filter as 1 in the filter it have to Million value , if user select metric id as 2 ehn it shd be in %

jaygarcia — Tue, 02 Jul 2019 12:36:02 GMT

I think your expression has an extra bracket ')' after [Gross Sales]. Remove it and the expression will be evaluated OK:

Try:

if(MetricId=1,
(sum([Gross Sales]/1000000)&'M',if(MetricId=2,num((sum(Units)/sum([Target Units])),'#.##%')))

Best regards,

Jay

manoranjan_321988 — Tue, 02 Jul 2019 13:55:07 GMT

Hi Tried,

Nothing is helping , facing again same issue.

manoranjan_321988 — Tue, 02 Jul 2019 13:56:24 GMT

Hi jay,

as per your suggestion rectified the brackets but not working pls help

manoranjan_321988 — Tue, 02 Jul 2019 14:57:33 GMT

is this achievable , pls suggest expertise