Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have defined two variables as follow;
vCYR = 1.19 & vLYR=1.84
I want to calculate the growth of the above and I used the following formula to generate the result;
($(vCYR) - $vLYR)) / $(vLYR)
The expected result in "-0.35", whereas I am getting "-0.00" as the answer.
The guidance and help on the above is highly appreciated.
Hi Baradwaj,
Thanks, for the formula.
Your formula gives -100.00% as the answer. I found the correct formula for the problem;
(($(vCYR)) - ($(vLYR))) / ($(vLYR))
The above formula works, and i do get the expected answers.
Cheers,
Kishore
You forget one brackets ($(vCYR) - $(vLYR)) / $(vLYR)
Try correcting parenthesis, like:
=($(vCYR) - $(vLYR)) / $(vLYR)
I have typed it correctly in the Qlike Sense, did a typing mistake here.
However, still I gt -0.00 as the answer.
Hi ,
Try the following expression:
($(vCYR)/$(vLYR))-1
Hope it helps
Regards
Hi.
I do something similar and use:
-1+($(vCYR)/$(vLYR))
John
Hi,
Attached the app for reference.
Hi Baradwaj,
Thanks, for the formula.
Your formula gives -100.00% as the answer. I found the correct formula for the problem;
(($(vCYR)) - ($(vLYR))) / ($(vLYR))
The above formula works, and i do get the expected answers.
Cheers,
Kishore
Hi Jhon,
Thanks for the formula, but the same as Baradwaj's formula it gives "100.00%" as the answer.
I have given the formula that works.
Cheers