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

    Where class

    Govind Ramchetty


      I have 1 report developed by single table.



      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



      Govind R




      A tablea.total
      a.total where Type=1