% computation

[tracycrown]

Dear all

Can someone help to enlightern me on how to compute the % in yellow below:

For example: Travel / School Fees = 25,000/500,000 = 5%

Desired Output
Desc	Jan-10	Jan-10
	Actual	%
School Fees	500,000	100.0%
Travel	25,000	5.0%
Stationery	50,000	10.0%
Salaries	350,000	70.0%
Total	425,000	85.0%

Thanks for your quick response, please send me a example QV file. Attached is an excel input file.

Tracy

[#2]

Hi Tracy

Do u wants like this? See this attachment.

Thanks

Zaman

[tracycrown]

Dear Zaman

At least this method do not require any creation of memory variable (same as Kevin's idea). I am still don't understand how to generate the following scripts, can you describe the steps :

FROM

(

biff, embedded labels, table is Sheet1$, filters

(Remove (Row, Pos(Top, 1)),

Remove

(Row, Pos(Top, 2)),

Transpose

(),

Remove

(Col, Pos(Top, 6))));

Thank you very much for your help, Tracy

[tracycrown]

Dear all

Can someone help to explain why and how to do the following in script :

(Remove (Row, Pos(Top, 1)), Remove

(Row, Pos(Top, 2)),

Transpose

(),

Remove

Thank you very much, Tracy

(Col, Pos(Top, 6))));