2 Replies Latest reply on Jul 29, 2016 5:27 AM by Tharashasank Davuluru

    Where class

    Govind Ramchetty

      Hi

      I have 1 report developed by single table.

       

      e.g

      Salary Table

       

      (sum total where Dep=sales)/Sum(Total)

       

      Sum total where Dep=Marketing/sum(total)

       

       

      How can i create calculated filed with where class condition ?

       

      Calculation filed1 -->(sum total where Dep=sales)

      Calculation Field2-->Sum total where Dep=Marketing

       

      Thanks

      Govind R

       

       

            

      A tablea.total
      a.total where Type=1