I have a script for Time to close an opportunity by days.
if(ceil(([Close Date]-[Created Date]),30)>0,ceil(([Close Date]-[Created Date]),30),'entered after close date')
I would like to show this by months. Can you help me changing the script?
I would use your existing expression to define 'Days to close' as a variable. Then you use the newly defined variable to define another variable, vMonthstoClose where it equals $(vDaystoClose)/30.
can you be a little bit clear on your reuirement?
Retrieving data ...