Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 %
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
Hi Tried,
Nothing is helping , facing again same issue.
Hi jay,
as per your suggestion rectified the brackets but not working pls help
is this achievable , pls suggest expertise