Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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.
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
Thank you!:)
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te| Related Posts | Răspunsuri | Vizualizări | Activitate | |
|---|---|---|---|---|
|
|
1
sept. 18
|
4614 | ||
|
1
iun. 23
|
3513 | ||
|
1
nov. 22
|
3796 | ||
|
Cannot create task
Rezolvat
|
|
2
iun. 20
|
3997 | |
|
2
iul. 18
|
7535 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
