You need to sign in to do that
Don't have an account?
Custom formula field needed!
Hello,
I tried to posting this on the answer board, and I also contacted support (but basic support does not help with building fomulas).
I need to create a custom field on the invoice itself to determine the number of days past due for any invoice that has an open balance. Then bucket by that field. Please see the sketch (link) to see what I'm trying to capture in a dashboard:
http://http://i1297.photobucket.com/albums/ag36/AdrielleSFDC/Capture.jpg
Thanks for the feedback!
"Remember that basic support gives support to the formulas already created but not handle the creation of new ones due to the fact that we do not know how they work in Salesforce environment, so for that most of time we recommend to our customers to visit developer.force.com so they can post the idea of the formula they want and most of the time other developers and system admin can give them some ideas how to create them."
hai,,,
as per my understanding of your problem,
Create a startdate field(Date type),
No.of days open( Number type),
Due Date( Formula type) on your invoice record.
now when you select Start date & No.of days,the due date will get updated automatically excluding weekends(sat & Sun Day).,,so, now you can Capture this on your dashboard i guess.
Good luck.
All Answers
hai,,,
as per my understanding of your problem,
Create a startdate field(Date type),
No.of days open( Number type),
Due Date( Formula type) on your invoice record.
now when you select Start date & No.of days,the due date will get updated automatically excluding weekends(sat & Sun Day).,,so, now you can Capture this on your dashboard i guess.
Good luck.
Thanks!