Mar 29 2021 07:24 AM
I made the custom function below in Power query, but results are not what I expect. If I put in 0.1 I get 50 instead of 0, for instance. Must be some stupid mistake or misunderstanding on my part, can anyone tell me what's wrong?
(vGrowth as number) =>
if vGrowth > 1 then 100
else if vGrowth > 0.5 then 50
else if vGrowth > 0.2 then 20
else if vGrowth > -0.2 then 0
else if vGrowth > -0.5 then -20
else if vGrowth > -1 then -50
else -100
Mar 30 2021 02:27 AM
SolutionIt works correctly
function is
(vGrowth as number) =>
let result =
if vGrowth > 1 then 100
else if vGrowth > 0.5 then 50
else if vGrowth > 0.2 then 20
else if vGrowth > -0.2 then 0
else if vGrowth > -0.5 then -20
else if vGrowth > -1 then -50
else -100
in result
Apr 01 2021 02:59 AM
Mar 30 2021 02:27 AM
SolutionIt works correctly
function is
(vGrowth as number) =>
let result =
if vGrowth > 1 then 100
else if vGrowth > 0.5 then 50
else if vGrowth > 0.2 then 20
else if vGrowth > -0.2 then 0
else if vGrowth > -0.5 then -20
else if vGrowth > -1 then -50
else -100
in result