percentage

[lana]

Hello,
I have to calculate a ratio and I wonder if I could do this with eviews. this is an example :
ratio = (rooa * 50% + rfff*100%)/(frghjh *12% + efsdgfs* 65%)
I tried with GENR ratio = ()/()
between brackets I put the variables but it didn't work

can I do this or I should do it in EXCEL ONLY ?
thank you

[trubador]

EViews has its own built-in functions just as Excel does. You should look up for the proper commands and correct syntax from the help files first.

And you should also provide more information in such cases. For instance, what are rooa, rfff, frghjh, efsdgfs or how do you decide that it does not work, is there an error message, and if so what does it say, etc.

If all these variables are series, then the following should work:

Code: Select all

genr ratio = (0.5*rooa + rfff) / (0.12*frghjh + 0.65*efsdgfs)

[lana]

sorry for the missing details and thank you for help