Bucket calculations in Cognos 8.4 report studio

• andy 90591

  SSC Journeyman

  Points: 83

  More actions

  October 29, 2010 at 6:46 am

  #240519

  The following table describes some data where I need to be able to have buckets of 0-5%, 5-10%, 10-20%, 20-35%, 35-65%, 65-80%, 80-90%, 90-95% etc...

  The problem is when the volume exceeds 5% (the smallest buckets) then it jumps a bucket. But the business needs to still show the 0-5% bucket with the 0.922 ANSP as this is also starting point. This could happen in any of the 8 buckets, and would then require previous ANSP value.....how is this possible in SQL using Cognos 8 report studio? Remember all 8 buckets must exist for this to work...

  PeriodANSP EUR CastTonnesRunning Total Volume ShippedTotal Volume ShippedRunning Total Volume Shipped %Group

  0-5% missing bucket

  2009100.92220,16020,160346,274.705.82%05-10% 

  0.9884021,000346,274.706.07%

  1.0651,40022,400346,274.706.47%

  1.0774,00026,400346,274.707.62%

  1.1124,98031,380346,274.709.06%

  1.1383,02434,404346,274.709.94%

  1.147,05641,460346,274.7011.97%10-20% 

  1.151,00842,468346,274.7012.26%

  1.2052,00044,468346,274.7012.84%

  1.2081,60546,073346,274.7013.31%

  1.2121,00847,081346,274.7013.60%

  1.22614,77861,859346,274.7017.86%

  1.2484,03265,891346,274.7019.03%

  1.2681,00866,899346,274.7019.32%

  1.2736,04872,947346,274.7021.07%20-35% 

  1.2751,10074,047346,274.7021.38%