Hi Team,
I need your help in unit conversions and % calculation.
Issue is I have a bar chart for sales for two consecutive years and the sale amount varies from year to year.(no dimension only expressions).
with my conversion expression bars are displaying their respective units(like millions and Billions).
but I have to show same unit for all the bars in the chart.
and the % also coming wrongly(Please have a look at attached snap.).
Expressions we are using are
Bars 1)Sum({<year={"$(Max(Year))"}Sales)---- for current year
2)Sum({<year={"$(Max(Year)-1)"}Sales
Unit Conversion:
if(Sum({<year={"$(Max(Year))"}Sales)>1000000,Num(Sum({<year={"$(Max(Year))"}Sales))/1000000,'#,##0.0M',Num(Sum({<year={"$(Max(Year))"}Sales)/1000,'#,##0.0K').
% Exp:(Sum({<year={"$(Max(Year))"}Sales)-Sum({<year={"$(Max(Year)-1)"}Sales))/Sum({<year={"$(Max(Year)-1)"}Sales.
Thanks in advance,
Anusha.K