Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Variable $(vCY2016) which tells visit-counts. ( it has set analysis in it). I have another variable $(vCY2016NHPN). Now I want to create percentage of Visit. i am not getting correct results.
Now my $(vCY2016) results is 6 and $(vCY2016NHPN) is 4 and that is coming correct.
for percentage I wrote the following code . it should come 4/10 *100 = 40 %
But this code is coming 7.5 .
=$(vCY2016)/$(vCY2016NHPN)+$(vCY2016)
Please suggest.
Regards,
Niha
Hi there
You are missing brackets so it is evaluating the division part first and then adding the $(vCY2016). Currently your expression is 6/4+6 which means it is 1.5+6 and that is equal to 7.5. Change it to $(vCY2016)/($(vCY2016NHPN)+$(vCY2016)) which will give you 0.4. You can just format it as a percentage.
Regards,
Mauritz
Hi there
You are missing brackets so it is evaluating the division part first and then adding the $(vCY2016). Currently your expression is 6/4+6 which means it is 1.5+6 and that is equal to 7.5. Change it to $(vCY2016)/($(vCY2016NHPN)+$(vCY2016)) which will give you 0.4. You can just format it as a percentage.
Regards,
Mauritz
Great! Only one bracket! It worked.
Regards,
Niha