Utilization = (Spent / Released) * (((Today-StartDate)+1)/DaysinQuarter)
My question is this: Can I calculate the Today - StartDate piece in a report ?
Thanks !!
6 respuestas
Hey Eric,
Its definitely attainable but you cant do it using a custom Report Formula. You'd need to add a custom field to the object which you are reporting on.
Is DaysinQuarter a static amount (ie always 90 days or is it 90days less todays progress into the quarter?)
Formula would look something like this:
((Spent__c / Released__c) * (((TODAY()-StartDate)+1)/90))
