How to create a percentage variable based on two other variables

[bashar_f]

Hi,

I have 2 variables,

vApplicationsCount  = Count(Apps)

vEnrolmentCount = Sum(Enrol_Status)

so basically in the end they are two numbers.

I need to create a new variable that is equal to the percentage of  enrolments over applications? 

% of Enr/Apps

What would the definition be?

[alexandros17]

You can do:

vNewVar = Count(Apps)/Sum(Enrol_Status)

or

vNewVar = $(vApplicationsCount)  / $(vEnrolmentCount )

[SergeyMak · Accepted solution]

Just because of percentage

vNewVar = NUM($(vApplicationsCount)  / $(vEnrolmentCount ), '#,##0%' ) Or you can use formatting from Number tab in you chart.

[bashar_f]

In the definition of the new variable, it recognizes when I type vApplicationsCount, is it really necessary to put the dollar sign here? Cant I just put the definition like this?

vApplicationsCount / vEnrolmentCount

Or

NUM(vApplicationsCount / vEnrolmentCount , '#,##0%' )

[SergeyMak]

It depends on your goal.

I usually use $-format

In case of vApplicationsCount you pass only text into the new variable. As I understand it will equal set vApplicationsCount='your text'

[bashar_f]

I understand, Thank you very much.