Skip to Content
This question has been flagged
projecttaskreportnegativev10
1 Reply
3261 Views
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
Discard
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
Discard
Willmore BattleShipNet
Author

Thank you!:)

Related Posts Replies Views Activity
Odoo project task created do not send email Solved
project email automated task v10
Avatar
Avatar
1
सित॰ 18
4610
v16 Tasks visibility
project task
Avatar
Avatar
1
जून 23
3500
Create a user who can only see project and task menu Solved
project task
Avatar
Avatar
1
नव॰ 22
3788
Cannot create task Solved
project task
Avatar
Avatar
2
जून 20
3982
How can I make the Project task completed?
project task
Avatar
Avatar
Avatar
2
जुल॰ 18
7527