|
Percentage change cross scenario reports |
Top Previous Next |
|
However we may still wish some percentage change calculations which we achieve by adding
Parameter savsummp(ordr,*,alli,scenarios) Comparative Farm Summary (percent chg); savsummp(ordr,measures,alli,scenarios)$savsumm(ordr,measures,alli,"base")= round( (savsumm(ordr,measures,alli,scenarios) -savsumm(ordr,measures,alli,"base"))*100 /savsumm(ordr,measures,alli,"base"),1); savsummp(ordr,measures,alli,scenarios) $(savsumm(ordr,measures,alli,"base") eq 0 and savsumm(ordr,measures,alli,scenarios) ne 0)=na; option savsummp:1:3:1;display savsummp;
which sets up a new parameter, computes percentage changes rounded to one place and sets them to na if the base number is zero yielding
---- 456 PARAMETER savsummp Comparative Farm Summary (percent chg)
beefp beefcorn
Scenario setup .price .Corn 22.7 Scenario setup .price .Beef 40.0 40.0 Scenario Results.Net Income .Total 129.7 131.0 Scenario Results.Land use .Cropland -3.8 -8.3 Scenario Results.Dry Cropping .Corn 14.2 59.9 Scenario Results.Dry Cropping .Soybeans 2.1 -14.5 Scenario Results.Dry Cropping .Total 2.5 -11.6 Scenario Results.Irr Cropping .Corn -19.6 Scenario Results.Irr Cropping .Total -19.6 Scenario Results.Livestock .cattle 40.7 40.7 Scenario Results.Resource Value.Water -100.0 -5.0 Scenario Results.Resource Value.Cropland -100.0 -100.0 Scenario Results.Resource Value.Pastureland 1629.0 1461.9 Scenario Results.Resource Value.April Labor 154.4 89.8 Scenario Results.Resource Value.May Labor 198.1 128.5 Scenario Results.Resource Value.Sept Labor NA NA Scenario Results.Resource Value.Oct Labor 301.8 658.4 Scenario Results.Product Value .Corn 6.4 22.7 Scenario Results.Product Value .Beef 40.0 40.0 Scenario Results.Product Value .Cattlefeed 3.9 13.8 |