Ratio Calculation

[upaliwije]

Hi Friends

DESCRIPTION	ACTUAL    2014	Actual Ratio	ACTUAL    2013	Actual Ratio
SALES	7,332,885	100	967,954	100
LABOUR	339,527	5	222,262	5
MATERIAL	831,338	11	338,969	11
COMMISSION	890,125	12	75,000	12
GROSS_PROFIT	5,271,896	72	331,722	72
STAFF_EXP	853,494	12	40,000	12
ADMIN_EXP	857,451	12	80,000	12
SELLING_EXP	509,639	7	100,000	7
TOTAL_EXPENSES	2,220,584	30	220,000	30
OTH_INCOME	40,000	1	40,000	1
NET_PROFIT	3,091,312	42	151,722	42

I have calculated Actual Ratio bases on the Sales Value of Each Year for 2014 and 2013.But The calculation returns the same ratios for  both years . Kindly have look at my QV document and help me to correct the expression to suit my requirement

Ex

Labour/Sales *100    339527/7332885*100=5%

Marerial/Sales*100     831338/7332885*100=11%

[jyothish8807]

Hi Upali,

In a single go if you want to display ratio for more that one year then you have you create different variable of that as per my knowledge.Other wise you can do $(vYear)+1 for next year and so on.So when you select 2013 it will show the output for all the years.

It may help.Right now i amusing PE so cant open your app.

Regards

KC