Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: Decimal places

    ,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.

Viewing post 1 (of 1 total)