Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
projecttaskreportnegativev10
1 Odgovori
3286 Prikazi
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
Opusti
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
Opusti
Willmore BattleShipNet
Avtor

Thank you!:)

Related Posts Odgovori Prikazi Aktivnost
Odoo project task created do not send email Solved
project email automated task v10
Avatar
Avatar
1
sep. 18
4614
v16 Tasks visibility
project task
Avatar
Avatar
1
jun. 23
3514
Create a user who can only see project and task menu Solved
project task
Avatar
Avatar
1
nov. 22
3798
Cannot create task Solved
project task
Avatar
Avatar
2
jun. 20
3997
How can I make the Project task completed?
project task
Avatar
Avatar
Avatar
2
jul. 18
7536