This topic is locked

report - how to make searchable a sum field

11/18/2019 3:09:35 PM
PHPRunner General questions
C
chrispa author

good day ,
i have a report with a field called overtime hours .

I sum the overtime hours for that field in that report.

Is there any way on the search panel to have the sum(overtimehours) field so in case i need to find the users that have a sum of overtime hours for example more than 50 to add that value in the search panel and to return the users with sum of overtime hours more than 50 ?
thanks in advance

Sergey Kornilov admin 11/18/2019

If you perform your calculations in the SQL query then calculated field will be searchable.