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%

[ariel_klien]

Hi

change the variable to:

vActual = sum({$<DESCRIPTION={'SALES'},YEAR=>}ACTUAL)

vBudget = sum({$<DESCRIPTION={'SALES'},YEAR=>}BUDGET)

BR

Ariel

[Anonymous]

I can't see the the similarity between values for both years.........in your application,

The values are different for different years..........

Whats your issue...

[upaliwije]

Values are different  but the Ratio is same for both years

[upaliwije]

Thanks

It is not working. Can apply it to my QV file and upload the files

[ariel_klien]

I attached the file

[Anonymous]

EVEN RATIO IS ALSO DIFFERENT ..............

Please see

[jagan]

Hi,

Put = in your variable declaration, then use this expression

(Sum(ACTUAL)/(vActual))*100

where vActual ::::: = sum({$<DESCRIPTION={'SALES'},YEAR=>}ACTUAL)

Putting = will evaluate the expression and stored values in variable.

Regards,

Jagan.

[upaliwije]

Pls have a look at Years Sheet

[upaliwije]

It wont give the desired results

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

Sales Ratio should be 100% (7332885/7332885)*100

and Ratio for both years are same