Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

select a.service_type, a.base_type, a.base_absid, a.year,a.month, round(utilization_in / (b.speed* 1000000),4) as 'avg_capacity_in',   ##changed the round from 2 to 4 in order to show 4 decimal values as requested by Emma in ticket 2019091834001379 

...