% between 2 grouping fields

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  November 21, 2005 at 6:58 am

  #188600

  well i have ds that get scrap qty From machin production(say cans).

  In RS i have group1=department,group2=machin(Each department there's machins).Each group i have a sum of the scrap=SUM(Fields!scrap.value).Now,i want 2 show the % between group2 and group1 how can i write this???It's the same syntax!?

   

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  November 22, 2005 at 2:40 am

  #605161

  Well i found solution:

  (Sum(Fields!scrap.value,"GroupName2")/Sum(Fields!scrap.value,"GroupName1"))*100