Skip to Content
This question has been flagged
projecttaskreportnegativev10
1 Respondre
3275 Vistes
Avatar
Willmore BattleShipNet

In report "Tasks Analysis" in module "Project" when I select measure "#Days to deadline" it shows negative values for those tasks that have missed deadline.  Can I somehow format that field to show positive values in this report?

Note: in database view this field must not loose sign because users use filter "#Days to deadline" less than 0" to filter out all tasks that have missed deadline.

Avatar
Descartar
Avatar
Sushma
Best Answer

Hi Willmore,

Update task analysis select query to (abs((extract('epoch' from (t.date_deadline-(now() at time zone 'UTC'))))/(3600*24)))::NUMERIC::INTEGER as delay_endings_days

This statement includes your question https://www.odoo.com/forum/help-1/question/round-a-field-value-in-report-display-139265

Avatar
Descartar
Willmore BattleShipNet
Autor

Thank you!:)

Related Posts Respostes Vistes Activitat
Odoo project task created do not send email Solved
project email automated task v10
Avatar
Avatar
1
de set. 18
4612
v16 Tasks visibility
project task
Avatar
Avatar
1
de juny 23
3507
Create a user who can only see project and task menu Solved
project task
Avatar
Avatar
1
de nov. 22
3795
Cannot create task Solved
project task
Avatar
Avatar
2
de juny 20
3995
How can I make the Project task completed?
project task
Avatar
Avatar
Avatar
2
de jul. 18
7535