Num Format

[manoranjan_321988]

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]

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]

Hi Tried,

Nothing is helping , facing again same issue.

[manoranjan_321988]

Hi jay,

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

[manoranjan_321988]

is this achievable , pls suggest expertise