,case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000
when f.HAI ='B' then (isnull(f.NUM,0)/f.den) *1000
when f.HAI ='C' then (isnull(f.NUM,0)/f.den) *1000
when f.HAI ='D' then (isnull(f.NUM,0)/f.den) *1000
when f.HAI = 'E' then (f.NUM/f.den) *100
Story in...
- This reply was modified 3 years, 9 months ago by Shukla182.
- This reply was modified 3 years, 9 months ago by Shukla182.