• Registered: 2015-10-20
  • Posts: 23

Topic: SUM of a field

Hi

How can I do a SUM of a numerical field with and without a filter .

Example a field cald PROFITS I want to make sum of all fileds in all raws that contain a value bigger then 100 ?

how can it be done ?

Elico

  • Registered: 2014-02-14
  • Posts: 10,294

Re: SUM of a field

You can use calculated field for that purpose:


(SELECT TOTAL(profits) FROM tablename WHERE profits > 100)
Dmitry.
  • Registered: 2015-10-20
  • Posts: 23

Re: SUM of a field

Thanks
Elico