# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for
Did you mean:
Highlighted Contributor II

## Calculating Growth Rate Using Variable

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.

Tags (6)
Labels (4)

• ### Variables

1 Solution

Accepted Solutions
Highlighted Contributor II

## Re: Calculating Growth Rate Using Variable

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

8 Replies
Highlighted Contributor III

## Re: Calculating Growth Rate Using Variable

You forget one brackets (\$(vCYR) - \$(vLYR)) / \$(vLYR)

Highlighted MVP

## Re: Calculating Growth Rate Using Variable

Try correcting parenthesis, like:

=(\$(vCYR) - \$(vLYR)) / \$(vLYR)

Highlighted Contributor II

## Re: Calculating Growth Rate Using Variable

I have typed it correctly in the Qlike Sense, did a typing mistake here.

However, still I gt -0.00 as the answer.

Highlighted Partner

## Re: Calculating Growth Rate Using Variable

Hi ,

Try the following expression:

(\$(vCYR)/\$(vLYR))-1

Hope it helps

Regards

Highlighted Partner

## Re: Calculating Growth Rate Using Variable

Hi.

I do something similar and use:

-1+(\$(vCYR)/\$(vLYR))

John

Highlighted Partner

## Re: Calculating Growth Rate Using Variable

Hi,

Attached the app for reference.

Highlighted Contributor II

## Re: Calculating Growth Rate Using Variable

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

Highlighted Contributor II

## Re: Calculating Growth Rate Using Variable

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