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