Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
3318 Visualizzazioni

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
Abbandona
Risposta migliore

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
Abbandona
Autore

Thank you!:)

Post correlati Risposte Visualizzazioni Attività
1
set 18
4633
1
giu 23
3538
1
nov 22
3841
2
giu 20
4045
2
lug 18
7574