opportunity age calculation coding help

[Nishan Perera]

Hi yuri

I need some support on opportunity age calculation which is now working perfectly. Thing is, I want to stop the age calculation if opportunity stage change to closed won or closed lost.

thread,

https://forum.espocrm.com/forum/general/52323-how-to-create-a-dynamiclogic-for-opportunity-age

[Nishan Perera]

hi, can anyone help me out on this ??

[Nishan Perera]

yuri looking for your support on this request.

[Nishan Perera]

Hi yuri

I need some support on opportunity age calculation which is now working perfectly. Thing is, I want to stop the age calculation if opportunity stage change to closed won or closed lost.

thread,

https://forum.espocrm.com/forum/general/52323-how-to-create-a-dynamiclogic-for-opportunity-age

can someone help me on this ?

[Nishan Perera]

update as below and worked for me.

for closed won only

"select": "DATEDIFF(CASE WHEN opportunity.status = 'closed won' THEN opportunity.completed_date ELSE NOW()END, opportunity.date_identified)",
"orderBy": "DATEDIFF(CASE WHEN opportunity.status = 'closed won' THEN opportunity.completed_date ELSE NOW() END, opportunity.date_identified ) {direction}",

or for closed won/lost or multiple

"select": "DATEDIFF(CASE WHEN opportunity.status IN ('Completed', 'Hold') THEN opportunity.completed_date ELSE NOW()END, opportunity.date_identified)",
"orderBy": "DATEDIFF(CASE WHEN opportunity.status IN ('Completed', 'Hold') THEN opportunity.completed_date ELSE NOW() END, opportunity.date_identified ) {direction}",