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%

[upaliwije]

Pls help me with an answer

[ariel_klien]

Hi

change the variable to:

vActual = sum(if(DESCRIPTION='SALES',ACTUAL))

vBudget = sum(if(DESCRIPTION='SALES',BUDGET))

BR

Ariel

[jagan]

Hi,

Did you tried my earlier reply.

Regards,

Jagan.

[upaliwije]

Tried But It won't Work.

Will you please further look into this and help me

[ariel_klien]

try to change the variable with 'IF' like in my earlier replay

[Anonymous]

PFA

[upaliwije]

Still not working please

[upaliwije]

Thanks Gupta

Your expression is working. You have created variable for each year. Is there a possibility of creating one variable and specifying the year through the expression. If possible Pls let me know

[jyothish8807]

Hi Upali,

PFA.

This automated as you want.It is depended on Single variable.

When you select 2013 the date will chage for 2013 and when you select 2014 the numbers will change.

Hope it may help.

Regards

KC

[upaliwije]

Thanks Kc

I am almost there with your QV document. But there is a little problem with the Ratio Calculation for the year 2013. Because I want Figures to appear in respect of several Years in different columns. Pls check and advise me