Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Just because of percentage
vNewVar = NUM($(vApplicationsCount) / $(vEnrolmentCount ), '#,##0%' ) Or you can use formatting from Number tab in you chart.
You can do:
vNewVar = Count(Apps)/Sum(Enrol_Status)
or
vNewVar = $(vApplicationsCount) / $(vEnrolmentCount )
Just because of percentage
vNewVar = NUM($(vApplicationsCount) / $(vEnrolmentCount ), '#,##0%' ) Or you can use formatting from Number tab in you chart.
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%' )
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'
I understand, Thank you very much.