Make measure #days to deadline show as positive values

Question

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.

Sushma · Accepted 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

相關帖文	回覆	瀏覽次數
Odoo project task created do not send email 已解決 project email automated task v10	1 9月 18	4637
v16 Tasks visibility project task	1 6月 23	3546
Create a user who can only see project and task menu 已解決 project task	1 11月 22	3849
Cannot create task 已解決 project task	2 6月 20	4052
How can I make the Project task completed? project task	2 7月 18	7583

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！